Hi, Good Morning
I appreciate if you have any requirements today, please forward to [email protected] . Please add me in your daily requirements distribution list Work Status: US Citizen Location: VA Background Summary: * Over 7 years of experience in Database Design and Development as MS SQL Server 2008,2005, 2000 Database / ETL Developer in Windows environment. * Experience in Information Technology on logical and physical Database design with Different Data Modelers using ERD, data normalization, scripts and implementation on MS SQL SERVER 2008/2000/2005. * Experience in Data modeling and Database Architecture based on functional requirements and system design of the client using RDBMS concepts and constructs. * Strong experience in Installation, configuration and upgrading of Microsoft SQL Server software and related products. Also involved in establishing and maintaining sound backup and recovery policies and procedures. * In-depth knowledge of T-SQL (DDL, DML, DCL) to perform batch processing and implement business logics into backend. * Hands on experience in Querying Data, Formatting Result Sets, Modifying Data and Worked on Transactions. * Extensive experience in creating Clustered, Non-Clustered, Covered indexes and indexed views. Balancing Index maintenance and using included columns. * Strong RDBMS concepts and experience in creating, maintaining and tuning Views, Stored Procedures, Functions and Triggers using SQL Server, T-SQL. * Involved in Backup, Restoring and Moving databases from heterogeneous sources to multiple environments. * Used T-SQL to manage databases by managing index fragmentation, managing statistics, shrinking files and performing DBCC Checks. * Proficient in implementing business logic and batch process in backend using Stored Proc and Functions. * Proficient in maintenance and optimization of Database and Server. * Extensive experience in Working with SQL Server Agent Jobs, Monitoring and Troubleshooting SQL Server Performance, Maintaining Database Snapshots, Implementing Database Mirroring, Log shipping and Managing Replication. * Experience in Data Extraction, Transforming and loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, Data Transformation Services (DTS), Bulk Insert, BCP). * Created Event-handlers, Transactions and Checkpoints to detect and handle processing errors. * Involved in securing and deploying SSIS Packages, Optimizing SSIS Packages by analyzing Memory Buffer Architecture and Applying SSIS to Data warehousing. * Good Experience in creating Master Child Packages in SSIS. * Hands on Experience in managing various SSIS Package Configurations in the form of XML Files. * Experience in pulling data from DB2 to SQL Server using SSIS. * Experience in Data modeling (Dimensional & Relational) like Star-Schema Modeling, Snowflake Modeling, fact and dimension tables. * Experience in creating multidimensional cubes using the SQL Server Analysis Services. * Extensive experience in Optimizing Cubes using SQL Server Analysis Services (SSAS) 2005. * Involved in designing Aggregations, User Hierarchies, Optimizing Aggregations and Tuple-based Calculated Members. * Good experience in querying with MDX, Designing Custom members, Developing KPI's. * Involved in interacting with cubes by linking to reports, adding drill through and using standard actions. * Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS). * Created Sub-Reports, Drilldown-Reports, Summary reports, and Matrix reports in SSRS. * A well-organized, goal-oriented, highly-motivated effective team member with excellent analytical, troubleshooting, and problem solving Skill. Technical Skills: RDBMS/DBMS: MS-SQL Server 2008, 2005, 2000, DB2, Oracle 11g Database Technologies/Tools: SQL Server Entreprise Manager, Microsoft Management Console, SQL T-SQL, Data Transformation Services (DTS), OLTP, BCP, SSIS, OLAP Reporting Tools: Microsoft SQL Server Reporting Services. (SSRS) Operating Systems: Windows XP, 2000, NT, 98, 95, Windows 2003 Programming Languages: HTML, C#.Net, Visual Studio, C++, T-SQL. Design Technologies/Tools: Erwin, MS Visio Data Warehouse / Business Intelligence Tools SQL Server Analysis Services 2005, Business Intelligence Development Studio Available Consultants: SQL, informatica, Oracle dev/DBA, BO, Cognos, .Net, QA, SAS, Data modeler, Teradata, OBIEE, ETL Arch, Datastage Thanks & Regards, Sri Mathew Zuven Technologies Inc 2222 Spring Creek dr, Ste 102 || PLANO, TX 75023 Cell: 469-361-2279 Mail to: <mailto:[email protected]> [email protected] Note: We respect your on-line privacy. This is not an unsolicited mail. Under Bill 1618 Title III passed by the 105th US Congress this mail cannot be considered Spam as long as we include contact information and a method to be removed from our mailing list. If you are not interested in receiving our e-mails then please reply with a "REMOVE" in the subject line. I am sorry for the inconvenience caused to you -- You received this message because you are subscribed to the Google Groups "KNOW.IT" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/know_it_az?hl=en.
