SUMMARY

• Over 9+ years of experience in IT industry performing Database Design, Development and Database Administration using SQL Server 2008/2005/2000 in Dev, Test and Production environments with various domains like Financial, Insurance and Health Care.
• Experience in software Analysis, Design, Development, Testing, Implementation and Production Support of Client/Server and Web based applications.
• Expertise in T - SQL (DDL, DML), Complex Queries, Tables, Views, Stored Procedures, Indexes, Cursors, User Defined Functions and Triggers.
• Experienced in Installing, Configuring, Managing, Upgrading, Migrating, Monitoring and Troubleshooting of SQL Server SQL Server 2008/2005/2000.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, MS Access, Oracle to MS SQL Server by using BCP utility and DTS/SSIS services.
• Expertise in Configuration, Logging, Error Reporting and Variables in SQL Server Integration Services to make package portable which Deployment and Troubleshooting.
• Designed and developed OLAP Cubes with star schema and Dimensions using SSAS. Querying and manipulating multidimensional cube data through MDX Scripting.
• Experience in performing Data Conversion, Data Scrubbing, and Data Transformations with SSIS Packages and stored Procedures.
• Experience of designing strategies for ETL audit, load balance, exception handling and high data volume.
• Strong working experience of Data Warehouse techniques and practices, experience including ETL processes, dimensional data modeling (Star Schema, Snow Flake Schema), OLAP, OLTP and Database performance tuning.
• Experience in design and implement processes for Deploying, Upgrading, Managing, and extracting data for reporting using SQL Server Objects.
• Experience in creating SSIS packages using Active X scripts and with appropriate Error Handling.
• Experience in creating jobs, SQL Mail Agent, Alerts and schedule DTS Packages.
• Experience in data normalization and data modeling using Erwin and Visio.
• Experience in Performance Tuning, T-SQL Query Optimization and Solving Blocking issues using Execution Plan, Profiler.
• Experience in Partitioning, Indexing schemes and Table Compression.
• Solid experience and outstanding knowledge of high availability SQL Server solutions, including Log shipping, Replication, SQL Server clustering and space management.
• Good knowledge of working with Informix, Netezza, My SQL, Oracle, DB2 databases.
• Having good knowledge of entire phases of Software Development Life Cycle SDLC .
• Experience in IT development Life Cycle in Investment Industry.
• Demonstrated leadership abilities and team work skills as well as the ability to accomplish tasks under minimal direction and supervision.
• Highly organized with the ability to manage multiple projects and meet deadlines.
• A team player with excellent interpersonal, communication and presentation skills.

TECHNICAL SKILLS

SQL Server Tools: MS SQL Server 2008/2008R2, 2005, 2000, Management Studio, Business Intelligence Development Studio, Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, DDL, DML, Stored Procedures, UDF, Triggers, DTS, Database Tuning Wizard, SSIS, SSAS, SSRS.

Operating Systems: Windows Server 2003/2000, Windows NT 4.0, Windows XP/98/95.

Data Migration: MSDTS, SSIS, BCP, Data Migration, Import/Export Wizard.

Languages/IDEs: C, C++, C#, T-SQL, VB6.0

Data Modeling: Erwin 4.x, MS Visio 2000/2003.

Web Technologies: ADO.NET, IIS, HTML, DHTML, XML, Web Services, Visual Studio 2005, MS FrontPage 98/2000

Reporting Tools: SQL Server 2008/2005 Reporting Services, Crystal Reports

Office Suite / Tools: MS Office 2007/2003

PROFESSIONAL EXPERIENCE

Confidential, NJ

ETL/BI Developer

Responsibilities:

• Involved in the complete Software development Life Cycle of the system and also in the design and development of the database for the system using various data modeling techniques.
• Created Complex ETL packages using SSIS to Import/Export data from different sources Netezza/DB2/Oracle/Access/Excel Sheets/Text files into staging table and then transform and load into the data mart for various analytical and reporting purposes.
• Actively participated as in team to gather requirements to Develop BI Project and also participated Designed Physical and Logical of Data warehouse.
• Participated in design of Staging Databases and Data Warehouse database using Star Schema which is including Table Store Procedure and Indexes in SSMS.
• Using Package Configuration to Migrate SSIS package from one environment to other.
• Creating Master Child Packages and running packages through Batch.
• Loading data from/to different sources Like Text files, Excel files, XML files.
• Loading data from/to Different Databases like Access, Oracle, DB2, Netezza and SQL Server, Informix.
• Used different control flow controls like for each loop container, Sequence container, Execute SQL task, Send mail task, Execute Package task, Data Profiling Task, File System Task, Execute Process Task etc.
• Used event handling to send E-mail on event like on error.
• Transferred Flat files from different sources to the ETL tier by using BCP.
• Created Profiling, Cleansing and auditing plans with SSIS Packages.
• Converted complex business logic into SQL Stored Procedures and User-defined functions to achieve functionality required by the UI team and to support efficient data storage.
• Applied Configuration, Logging, Error reporting to all packages to make package deployment easy and troubleshoot package on run time.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Database Statistics update and Re-Indexing.
• Standardized company reports by implementing SQL Server Reporting Services.
• Created different type of reports including: Cross-tab, Conditional, Drill-down, Sub reports, Drill-down and Parameter prompts.
• Created Custom Reports using Vb.net assembly and Expressions in SSRS
• Generated the various kinds of reports using Graphs and Images
• Deployed and Scheduled the Reports in Report Manager.
• Created SSIS Packages by using advance tools (i.e. pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate etc).
• Extracted, cleaned and validated from XML file into database using SSIS task (XML source).
• Migrated SSIS Packages and modified the packages accordingly to the new features of SSIS and carried out a migration of databases from SQL Server .
• Created Complex Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL.
• Deploying and scheduling Packages to Load Data daily, weekly, monthly and quarterly.
• Dynamically loading data from/to Flat files, Excel files Using SSIS.
• Worked closely with DBA team to regularly monitor system for bottlenecks and implement appropriate solutions.

Environment: MS SQL Server 2008R2, SQL Server Integration Services, MS Access 2007/2003, Management Studio, MS Query Analyzer, Visio, AQT, SQL profiler and SSRS, Netezza Database,DB2, Informix Database.

Confidential, IN

SQL Server Developer/ SSIS Developer

Responsibilities:

• Involved in performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Load data in Data ware House by using Slowly Changing Dimension (SCD - Type 1, 2, 3)
• Implemented Logic with lookup table to maintain Parent- Child relationship and maintain hierarchy.
• Used transformation like Merge Join, Pivot, lookup, Fuzzy lookup and slowly changing Dimension.
• Design OLAP cube using SQL Server Analysis Service. Design natural and navigational hierarchies in dimension.
• Deployed cube on SSAS server and Created partitions on cubes.
• Created different user level groups, and assigned appropriate permission level to the database using Credentials tool. This made sure that only the right person with enough authorizations would be able to see their corresponding Information
• Use Data Viewers in SSIS Packages to check the flow of data during Execution of Packages.
• Generated reports using SSRS that could be used to send information to different managers of Different Branch.
• Used C#.NET in script task and script components and made use of ADO.NET classes to manipulate data.
• Created different type of reports including: Cross-tab, Conditional, Drill-down, Sub reports, Drill-down and Parameter prompts.
• Designed and deployed Reports with Drop Down menu option and Linked reports
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Generated the various kinds of reports using Graphs and Images
• Deployed and Scheduled the Reports in Report Manager.
• Scheduled and maintained routine jobs, tasks, and alerts. For instance an alert would be sent to the manager of department, if the entire field were not entered by the data entry person regarding screening using SQL Server Agent prepared user manual and technical support manual

Environment: SSIS, MS SQL Server 2005/2008, MS Access 2003/200, Enterprise Management Studio, MS Query Analyzer, SQL profiler and SSRS.

Confidential, Memphis, TN

SQL Server Developer/ BI Developer

Responsibilities:

• Participated in designing the Logical model by using Erwin based on the business requirement.
• Implemented the logical design to the physical design by creating tables.
• Designed SSIS packages to migrate the data from different sources to ETL tier.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups.
• Extracted, cleaned and validated from XML file into database using SSIS task (XML source).
• Created SSIS Packages by using advance tools (i.e. pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate).
• Develop Functional/Technical specifications for SQL Server Reporting Services reports.
• Created different type of reports including: Cross-tab, Conditional, Drill-down, Sub reports, Drill-down and Parameter prompts.
• Designed and deployed Reports with Drop down menu option and Linked reports.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Generated the various kinds of reports using Graphs and Images
• Deployed and Scheduled the Reports in Report Manager.
• Created Stored Procedures that generated XML reports from SQL Server tables and vice versa using Open XML, For XML, and XML Paths.
• Used DDL and DML to writing triggers, stored procedure to check the data entry and payment verification at early stages before calling them
• Created and Executed the Stored Procedures and Complex Queries for Reports.
• Used DBCC commands to check physical and logical consistency of the databases and Rebuild indexes
• Optimized the performance of queries by modifying the existing index system and rebuilding indexes again with respect to the I/O.
• Maintained data integrity by Creating Constraints and Triggers.
• Facilitated easy user interface implementation and consistent data entry into the database by creating Views with triggers.

Environment: Microsoft SQL Server 2005, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Microsoft Access 2003, Microsoft Excel 2003, Microsoft Visual Studio .NET 2003, ASP.NET, XML, SQL Profiler, ER-Win, T-SQL.

Confidential, AL

SQL Server Developer

Responsibilities:

• Created new database logical and physical design to fit new business requirement and implemented new design into SQL Server 2005.
• Migrated DTS packages to SSIS and modified the packages accordingly to the new features of SSIS and carried out a migration of databases from SQL Server .
• Participated in database logical design to fit new business requirement, and implemented new design in SQL Server 2005
• Filtered bad data from legacy systems using T-SQL statements, and implemented various constraint and triggers for data consistency.
• Drop and recreate Index on the DSS system while migrating data.
• Wrote complex T-SQL Queries to perform data validation and graph validation to make sure test results matched back to expected results based on business requirements.
• Created TNS entries on workstations to implement connectivity to Oracle 10g server.
• Used Toad to created complex stored procedures in Oracle using PL/SQL.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Deployed reports to Report Manager and Troubleshooting for any error occur in execution.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.
• Maintaining remote and central databases for Synchronization of data and preparing plans for Replication.
• Documentation of all the processes involved in maintaining the database for future reference.
• Develop documentation that sufficiently describes technical deliverable as required for internal controls and maintaining documentation of the database for future reference.

Environment: s: SQL Server 2000/2005, Oracle 10g, Toad, SQL Server Integration Services, MS Excel 2003, MS Access 2003, Enterprise Manager, Management Studio, SQL Profiler, and SSRS.

Confidential

SQL Server Developer

Responsibilities:

• Created and configured the database, with 2 file groups, created the tables having required constraints.
• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2000.
• Wrote stored procedures and functions using PL/SQL in Oracle 9i.
• Worked on Log Shipping, Replication to restore Database backup.
• Validated change requests and made appropriate recommendations. Standardized the implementation of data.
• Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.
• Modified database structures as directed by developers for test/develop environments and assisted in coding, design and performance tuning.
• Backup and restore databases.
• Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
• Created the DTS Packages through ETL Process to vendors in which records were extracts from Flat file and Excel sources and loaded daily at the server.
• Updated the statistics info for both the old and new servers.
• Managing logins, roles, assigning rights and permissions. Created views to implement security.
• Backing up master & system databases and restoring them when necessary. Supported production environment.
• Managing logins, roles, assigning rights and permissions. Created views to implement security.

Environment: - MS SQL Server 2000 Query Analyzer, Enterprise Manager, Oracle 9i, DTS Designer, SQL Profiler, Index Tuning Wizard, MS Access & Windows NT platform.