SUMMARY

• Over 5 years of IT experience in Database Development, Administration, Data Analysis, System Analysis, Design, Development and Support of MS SQL Server 2017, 2016, 2014, 2012, 2008in Production, Testing and Development.
• Extensive experience in interacting with business users, gathering requirements, data analysis, data mapping, gap analysis and documentation.
• Experience with software development life cycle (SDLC), Agile / Scrum and Project Management Methodologies. Extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects.
• Experience in writing Complex T - SQL Stored Procedure and constructing Tables, Triggers, user functions, Views, Indexes, Relational data models, Cursors and data integrity, SQL joins and writing Sub Queries.
• Well versed in designing highly flexible Database Architectures and Data Modeling, Data Mapping, Table Normalization, performance tuning and optimization of SQL scripts and SQL queries.
• Expertise in creating and managingPackage Configurations, Logging system, Packagedeployment and User-defined Variables for SSIS Packages.
• Experience working with Data Cleansing technique, different types Dirty Data from different sources.
• Expertise in Merging data from various Heterogeneous sources, Populating Dimension and Fact tables inData warehousesand Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.
• Strong knowledge in designingExtraction, Transforming and Loading(ETL)data flows using creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS.
• Experience in using Performance Monitor,SQLProfiler and optimizing the queries, tracing long running queries and deadlocks
• Hands on experience in creating and migrating AOL objects such as Concurrent programs, Value sets, Menus, functions.
• Experience in DTS Migration and Metadata Management: Migrating DTS packages to Package Migration Wizard, and Storage Management using SSIS (SQL Server Integration Services).
• Expert in creating various types of reports like complex drill down reports&drill through reports, Matrix reports, sub reports and charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.
• Experience in cubes construction based on data volumes mostly adhering to Star Schema using strong knowledge of Data Warehousing, Star Schema, Fact and Dimension Tables. Frequent use of ERWIN to design Normalized and De-Normalized Data Models.
• Excellent communication skills with capability to form and maintain positive and productive working environmentas an individual or a team player.

TECHNICAL SKILLS

Operating systems: Windows 98/NT/2000/XP/Vista/Windows7/8

Databases: MSSQLServer 2005/2008,2012/2014, MS Access

Database Tools: SQLEnterprise Manager,SQLProfiler, DTS Import/Export,SQLClient Configuration utility, Backup Server, Replication Server, OLAP Services,SQLServer Management Studio,SQLServer Business Intelligence Development Studio (BIDS)

ETLTools: DTS,SQLServer Integration Services,SQLServer Analysis

Reporting Tools: SSRS, R studio, Crystal Reports, Congo's, Micro Strategy

Development Skills: TransactSQL(T SQL), PL/SQL

Languages: C, C++, HTML, XML, VB.Net, Asp.Net (C#)

Application Packages: Microsoft Office Suite

PROFESSIONAL EXPERIENCE

SSIS/SQL Developer

Confidential, Irving, Texas

RESPONSIBILITIES:

• Responsible and active in the analysis, design, implementation and deployment of full Software Development Lifecycle (SDLC) of the project.
• Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Created database objects like tables views, materialized views, procedures and packages using oracle tools like SQL Developer.
• Created SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Worked on SQLLoader to load data from flat files obtained from various facilities every day.
• Designed and tested (Unit, Integration and Regression) packages to extract, transform and load data using SQL Server integration services (SSIS).
• Created and executedSSISpackages to populate data from the various data sources for different data loading operations for many applications.
• Migrated data between different heterogeneous sources such as Flat file, Excel usingSSIS.
• Partitioned the fact tables and materialized views to enhance the performance.
• Extensively used bulk collection in SQL objects for improving the performing.
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
• Worked extensively in various kinds of queries, Sub- Queries, Correlated Sub-Queries, Dynamic SQL, and Union Queries.
• Used SQL hints and indexes to improve SQL performance and analyzed the schema tables to get the better performance.
• Developed procedures for validation and error reporting on the data in the intermediate tables as well as created user defined Exceptions while handling exceptions
• Transferred data from various OLTP data sources, such as Oracle, Teradata, MS Access, MS Excel, Flat files, CSV files into SQL Server 2008.
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence container and Conditional split, Data conversion, Derived column and Multi casting.
• Worked on parameters to generate cascaded parameterized reports along with that extensively used global variables, expressions and functions.
• Generated reports that can handle dynamic grouping and dynamic sorting for efficient and clear viewing of the reports.
• Developed Sub Reports, Matrix Reports, Charts, and Drill Down Reports, using SQL Server Reporting Services (SSRS).
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
• Analyzed reports and fixed bugs in stored procedures on the ongoing database operations, as needed, to resolve business problems.
• Performed Server level tuning, performance monitoring, Index Tuning, Query Tuning.

Environment: SQLServer 2012/2016 Enterprise Edition, Enterprise Manager, JavaScript, DAX, ERWIN, UML, MS Project, Windows 2003 Server, .NET, C#, ASP.NET, SSIS, SSRS, SSAS.

MSBI Developer

Confidential, Dallas, Texas

RESPONSIBILITIES:

• Involved in Design and Development phase meetings for Business Analysis and requirement gathering.
• Developed Database application to meet business need using Oracle SQL features. Created Packages, Procedures, Functions and Triggers.
• Implemented parallel processing using DBMS SCHEDULER, DBMS JOBS and SQL Hint. Created parallel pipelined Table functions.
• Fixed dead lock occurred in existing application due to un-indexed foreign keys. Modified logic in existing application to ensure strict ordering of updates are performed.
• Tuned SQL packages and views to optimize performance and resolve bottlenecks, problems and space utilizations in acceptable time frame
• Tuned queries doing repeated PL/SQL function calls, used scalarsub-queries instead. Created views embedding function logic into SQL.
• Assisted with Troubleshooting and corrections for availability and performance of database objects such as views and packages
• Removed unwanted fields from query to use index, modified code to replace aggregates with analytical functions.
• Wrote script to find unused index in overly indexed environment. Monitored environment for a week and dropped unused index, performed index rebuild as required after data archival.
• Tuned queries using nested views and analytic functions. Wrote pagination queries for generating different reports.
• Involved in Dimension Modeling, Star Schema, designing Dimensions, facts for Data Warehousing, ETL and OLAP Cubes.
• PreparedETL Architectural Documents, Process flow diagrams and Mapping Documents.
• Involved in Regression Testing, Throughput Testing and Performance Testing during Oracle 11g Upgrade. Tuned some of the long running queries and applications to use Oracle 11g features.
• Performingdata management projects and fulfilling ad-hocrequests according to user specifications by utilizing data management software programs and tools like Excel and SQL.
• Involved in extensiveDATA validation by writing several complex SQL queriesand Involved in back-end testing and worked with data quality issues.

Environment: SQLServer 2010, Visual Studio-2010, SSRS, SSAS, SSIS, T-SQL, and TFS, MSSQLServer 2005/2008, Visual Studio-2006, T-SQL, MS-Office, MS-Excel, VSS

ETL Developer

Confidential, Seattle, Washington

RESPONSIBILITIES:

• Played role in design of scalable, reusable, and low maintenance SSIS templates.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms such as Lookup, Fuzzy grouping and Row Count Transformations and type 1 and type 2 slowly changing dimensions.
• Developed, monitored and deployed SSIS packages and user Defined Functions for giving Scores and views for the application. Generated reports from SSRS SQL server reporting services and SSAS.
• Created SSIS packages for application that would transfer data among servers and perform other data transformations.
• Scheduled SSIS packages by creating the jobs using job scheduler.
• Created SSIS package to Export and Import data from SQL Server to Access, Text and EXCEL files and Configured SQL mail agent for sending automatic mails.
• Created Scorecards and added them to dashboard using Dashboard Designer and deployed the dashboard to SharePoint.
• Generated parameterized reports to enable/disable the parameters based on user selection in SSRS.
• Worked on performance tuning, writing stored procedures and creating indexes.
• Implemented complex stored procedures and automated them using SQL Server Agent.
• Created triggers (Instead Of and after) for auditing purposes.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Proficient in creating and tuning database, developing views and having good exposure of C# and .NET Framework.
• Created SSIS packages for ETL flow to validate, extract, transform and load data into database. Involved in performing migration of DTS packages to SSIS packages.
• Configured Connection Manager files for SSIS packages to dynamically execute on QA server and Production server.

Environment: MSSQLServer, T-SQL, PL/SQL,SSIS, SSRS, SSAS,SQLServer BIDS, MS- Visual Studio, ASP.Net, C#.Net, ADO.Net, XML, MsVisio2003/2007, MS Project.