SUMMARY
- MS SQL Database/Business Intelligence developer wif over eight (8) years of experience wif MS SQL Server 2012/2008/2005/2000 in various industries including finance, educational, health care and law enforcement
- Experience wif installation and configuration of SQL Server 2012/2008/2005/2000
- Extensive experience in MS SQL Server 2012/2008/2005 BI tools like SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS)
- Experience using T - SQL for developing complex Stored Procedures, Tables, Views, Triggers, User Defined Functions and data import/export functions
- Hands on experience in analyzing query plans, fine-tuning and optimizing queries using SQL profiler and query execution plans, managing Indexes, Locks and troubleshooting deadlocks
- Extensive experience in complete life cycle of SSIS Packages (Developing, deploying, scheduling, troubleshooting and monitoring) for performing data transfers and ETL purposes across different servers
- Proficient wif extraction and migration of data from various data sources like MS Access, Oracle, Excel, flat files and XML to teh SQL Server using import/export wizard, DTS/SSIS, bulk insert and BCP utilities
- Highly experienced in providing Logging, Package Configurations, Error Handling using Event Handlers and custom logging for SSIS packages
- Experience creating Cubes wif Dimensions and Fact tables in OLAP using SSAS and creating calculated measures and dimension members using Multi-Dimensional Expressions (MDX)
- Proficient in creating Drill Down Reports, Ad-Hoc, data driven subscription, Parameterized reports, Charts using SSRS and MS Excel for data analysis
- Strong understanding of teh principles of data warehousing using Fact Tables, Dimension Tables, star and snowflake schema and Slowly Changing Dimensions
- Working knowledge in C#, ASP.Net and big data technologies like MapReduce, PIG, HIVE, HBase and SQOOP
- Highly experienced in data architecture design and used data modeling tools like Erwin for designing teh logical and physical data models
- Thorough knowledge in understanding teh business process, gathering requirements and coordinating ongoing iterative development of Software Development Life Cycle (SDLC)
TECHNICAL SKILLS
RDMS: MS SQL Server 2000/2005/2008/2012 , Oracle, MS Access
Database Tools: BIDS 2005/2008, SSDT 2012, Management Studio, Visual Studio, Analysis Services (SSAS), Query Analyzer, SQL Profiler, TFS
Data Modeling Tools: MS Visio 6.0, ER Studio 8.0.1, ERWIN 7.3
Programming Languages: SQL, T-SQL, PL/SQL, C#.Net, ASP.Net
ETL Tools: Data Transformation Services (DTS), SQL Server Integration Services (SSIS) Import/Export Wizard, Bulk Insert, BCP
Reporting Tools: SSRS, Report Builder, Active Reports, Crystal Reports
Applications: MS Officer 2000/2003/2007/2013
Operating Systems: Windows 2000/XP/ 2003/2007/2010
PROFESSIONAL EXPERIENCE
MS SQL Database/Business Intelligence Developer
Confidential, Greensboro, NC
Responsibilities:
- Planned, defined and designed data based on business requirements
- Developed, implemented and maintained various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views
- Used SSIS and SQL procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse
- Created jobs, alerts and scheduled SSIS packages using SQL Agent
- Used SQL Server package configurations in SSIS packages for code promotion to Dev, Test and Production Environments
- Identified database tables for defining queries to generate reports for analysis of data using SSRS
- Performed T-SQL tuning and optimization of queries that took longer duration using SQL Profiler, SQL Query Analyzer and execution plans
- Created different types of reports including Cross-tab, Conditional, Sub reports, and parameterized report
- Scheduled Monthly Adherence for client and daily exception reports for nursing and IT groups.
- Developed and implemented procedures to ensure teh quality, usability and accuracy of reports
- Used Team Foundation Server (TFS), and Visual Source Safe (VSS) to store, run, edit and revert back to different versions in case of system crash
- Involved in entire project life cycle including database design, development, testing, optimizing, and deploying on development and test servers
Environment: MS SQL Server 2008/2012, Microsoft Visual Studio 2012, SSIS, SSRS, T-SQL, C#, MS Excel, MS Windows/XP, Visual Source Safe, Team Foundation Server, SQL Profiler and SharePoint.
MS SQL Database/Business Intelligence Developer
Confidential, Seattle WA
Responsibilities:
- Analyzed data to identify patterns and trends that may impact overall performance
- Worked closely wif PM and other teams to create and test teh mappings from Source to Target
- Created database objects like Stored Procedures, Triggers and User Defined Functions
- Created views to maintain security of teh customer data
- Created Indexes to achieve high level performance
- Performed ETL operations to support incremental, historical data Loads and Transformations using SSIS
- Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call packages
- Created ETL packages wif different data sources and loaded teh data into destination tables by performing transformations using SSIS
- Used various SSIS functionalities like Joins, Conditional Splitting, Multi-cast, Union All and column conversions for better performances during teh package execution
- Implemented Slowly Changing Dimensions for storing history using SSIS packages
- Involved in teh design, development and maintenance of different cubes using SSAS
- Maintained log information in text files to track errors and record teh package execution status
- Developed various reports like Table, Matrix and Chart, Drill Down, Drill Through, Sub Reports, Parameterized, Table, Matrix and Chart reports using SQL server reporting services
- Created reports using teh Power BI Desktop App and Power BI Service
- Scheduled reports daily, weekly and on a monthly basis as per teh client’s requirements
- Wrote teh business logic codes using C# to read data from Stored Procedures
- Created user-friendly interfaces for different group users using ASP.Net for running different kinds of reports
- Configured mail profiles for sending automatic mails to teh respective people when a job failed or succeeded
- Implemented unit and integration tests
Environment: MS SQL Server 2000/2005/2008/2012 , SSIS, SSRS, SSAS, C#, ASP.Net, Power BI, Team Foundation Server, SQL Profiler, Query Analyzer, Visual Studio 2008/2013 and T-SQL
MS SQL Business Intelligence Developer/Data Analyst
Confidential, Cleveland OH
Responsibilities:
- Analyzed teh client requirements and translated them into technical specifications
- Created new database objects like Stored Procedures, Functions, Views, and Indexes using T-SQL in development, tests and production environment for SQL Server 2008
- Developed SSIS packages to Extract, Transform and Load into teh data warehouse from Heterogeneous databases such as Oracle, MS Access and DB2
- Developed SSIS packages wif monitored features and Logging capturing teh audit information of teh package and their execution results for support and troubleshooting
- Created SSIS packages to pull data from teh SQL Server and exported to various data sources like excel, flat files and vice versa
- Worked on SSIS performance tuning using counters, Error Handling, Event Handling and re-ran teh failed SSIS packages using checkpoints
- Scheduled SSIS packages as a job, to run on a daily basis for data loading
- Created AD-hoc reports and data driven subscription reports using Report Builder
- Created Drill-Down, Parameterized, Sub Reports, Pie Chart and Bar Chart reports
- Monitored teh performance of teh reports and modified SQL queries and functions to improve reports performance
- Administered teh reports by creating roles and providing permissions for teh users/groups
- Studied teh existing OLTP system(s) and created Facts, Dimensions and star schema representation for data warehouse
- Created cubes on top of teh data warehouse for reporting purposes
Environment: MS SQL Server 2005/2008, Windows 7, SSIS, SSAS, SSRS, SSMS, ER Studio, C#.Net, Query Analyzer