SUMMARY

• 8 years of IT experience and expertise in Designing, Development, Implementation and Maintenance of applications. Strong programming knowledge in TSQL, SQL.
• Development SQL SERVER and Report Development (SSIS, SSRS), Performance Analysis, Deployment Script Development, Production Support.
• Expert in Creating, configuring and Fine - tuning SSIS packages, SSRS reports and T-SQL queries using tools like SQL profiler Monitoring tool.
• Experience in creating jobs, alerts, SQL mail agent, and schedules for SSIS Packages in SQL Server Agent.
• Excellent experience in Designing, Maintaining and tuning various RDBMS like T-SQL & MS SQL Server and MS Access databases.
• Highly proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and data Integrity, SQL joins and query Writing.
• Strong experience in Database Installation, Capacity Planning, Implementing Backup and Recovery Strategy for application and database.
• Involved in performing Unit Test, Regression Test, Functional Test, integration Test, Stored Procedure Performance Test, on Test server and preparing combinedDeveloperTraining document along with waterfall, Spiral and Agile methods with full SDLC (Software Development Life Cycle).
• Expert knowledge and experience authoring, managing and deploying reporting solutions using SSRS.
• Experience in Report Subscriptions.
• Experience in Drill down/up and Drill through reports, cross tab reports, matrix reports.
• Experience in generating writing parameterized queries, drill through reports and formatted SQL server Reports in SSRS 2014/2012/2008 R2/ 2008/ 2005 using data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
• Good experience in MDX scripting and created Multi-dimensional expressions using MDX scripting.
• Ability to work well in hybrid and dynamic environments without supervision, as well as able to prioritize and remain focused on the essence of an issue while deploying iterative development methodologies in accomplishing a given task.
• Experience in installation, configuration, Development of MS SQL Server Reporting Services.
• Very good experience with ETL (Extract, Transform and Load) processes for OLTP & OLAP environments Experience in Reporting Services (SSRS Crystal Reports & Integration Services (SSIS).
• Report Service experience with Microsoft Excel Power Pivot.
• Experience in configuration of report server and report manager scheduling, permissions to different level of users in SQL Server Reporting Services (SSRS).
• Excellent communication skills, analytical skills, understand business requirements in various domains.
• Quick learner and good performer both in team and independent job environments.
• Excellent communication skills, analytical skills, understand business requirements in various domains. Effectively manages time spent on multiple projects to meet deadlines.

TECHNICAL SKILLS

Databases: SQL server 2014/2012/2008 r2/2008, Teradata, Oracle and MS Access.

Operating Systems: Linux, Windows 2008/2003/7.

OLAP/Reporting Tools: SSAS, (SSRS), MDX.

ETL Tools: SQL Server Integration Services (SSIS), SQL Server DTS.

Other Tools: Microsoft Visual Source Safe, Microsoft Office, MS Visio.

Data Modeling Tools: Microsoft Visio, Erwin.

SQL Server Tools: SQL server Management Studio, SQL server Query Analyzer, SQL server mail service, DBCC, BCP, SQL server profiler.

Programming languages: C, SQL, PL/SQL, T-SQL, .NET, C#, C++.

Data Warehousing & BI: SQL Server, Business Intelligence Studio, SSIS, SSAS, Access Manager, SQL Server 2008 Analysis Services and SQL Reporting services.

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

SQL Server Data Analyst

Responsibilities:

• At the staging server, data was loaded from different sources like flat delimited text files, and Excel spread sheets to the SQL Server database tables and from SQL server database to output flat files.
• Repaired joins, created new joins, built standalone filters, prompt Pages, Cascading Prompts,Calculations, merge query subjects in to new query subject, determine hierarchy and dimension information in Framework Manager and Published packages Created SSIS packages with Error and Event Handling, Precedence Constraints, Break Points, and Logging.
• Developed, maintained and monitored all import/export and Data Transformation into the Staging, Production and Data Warehouse environments.
• Used Derived Columns to get handle of null values and invalid data.
• Used different SSIS Transformations like Fuzzy Grouping, Fuzzy Lookup, Lookup to transform data and data type conversion.
• Designed packages for Rollup tables based on the business rules used by the reports.
• Applied SSIS Transformations like Conditional Splits, Multicast to integrate Business Rules.
• Inserted data into Fact and Dimension Tables using Slowly Changing Dimensions (Type1, Type2 changes) Task of SSIS.
• Tested, Cleaned, and Standardized Data to meet the business standards using Execute SQL task, Conditional Split, Data Conversion, and Derived column in different environments.
• Created complex SSIS packages for data cleansing, involving various tasks such as for each loop, file system task, and multicasting.
• Interacted with Strategic Development Team, Business analyst and Nurse Managers to analyze business needs and developed technical specifications.
• Created Tabular reports from SSAS Cubes.
• Created sub reports and connected Reports.
• Created Tab Reports.
• Created Standard, Cross-tab, Sub reports.
• Created and developed Parameterized, Drill Down and AD Hoc Reports using SQL Server 2008 Reports Services (SSRS).

Environment: SQL Server 2012/2014, SSRS, SSIS, SSAS, visual studio 2013, C#, Windows server 2008r2, SQL Server Data Tools.

Confidential, Minnesota

Sr. MSBI Developer

Responsibilities:

• Created Database Objects Schemas, Tables, Triggers and Constraints.
• Designed and developed the Staging Database and loaded from source to staging and from staging to the Destination tables applying different transformations.
• Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).
• Developed Complex Packages to load data into Stage and Data Ware House systems.
• Extracted data from various sources like SQL Server, Oracle, .CSV, Excel and Text file from Client servers and through FTP.
• Developed SSIS packages using Lookup Transformations, Merge Joins, Fuzzy Look Ups, and Derived Columns with Multiple Data Flow tasks.
• Used different Control Flow Tasks and Data flow Task for Creating SSIS Packages.
• Used different types of Transformations for Data Conversion, Sorting and data cleansing from different Sources into Company Formats.
• Created XML Package Configurations, Error Handling using Event Handlers for On Error, On Warning, and On-Task Failed Event Types.
• Extracted Data from Database tables to different file formats (Pipe, CSV, Tab, Tilde, Fixed Width).
• Created Jobs and scheduled Packages using SQL Server Management Studio for the Daily, weekly, Semi Monthly, Monthly and Annual Loads.
• Created Maintenance Plans and setup log files to monitor jobs.
• Performed Data Cleansing and Data Profiling using several transformations like Data Conversion and Derived Column.
• Work withdevelopers, DBA, and systems support personnel in elevating and automating successful code to production.
• Provide on-call support to production system to resolve any issues.
• Performed documentation of standards, best practices, and ETL procedures.
• Created right indexes on right tables to improve the data mart performance.
• Created SSIS packages following the naming conventions and all other boundaries.
• Experience in creating Multidimensional cubes using SSAS and designing DW schemas.
• Created calculated measures and dimension members using multi-dimensional expression (MDX).
• Created SSIS packages that involve incremental loads and maintaining SCD's.
• Created SSRS reports using Charts and different business logics.
• Deployment to all environments following the change management process.
• Tuned SSIS packages as part of maintenance, which used to slow down because of huge amounts of data.
• Completed the upgrade from 2008 to 2012 project model utilizing project parameters and connections.
• Have made changes to SSRS reports and designed many new reports using complex features to give the best satisfaction to end users Top.

Environment: SQL Server 2008r2/2012, Power Pivot, Power View, SSIS 2008/2012, SSRS 2012,SSAS 2012, SSMS and SQL & T-SQL, Sales Force.

Confidential, South Bend, IN

SQL Server Developer

Responsibilities:

• Installed and configured SQL Server 2008r2 on Development, Stage and Production Servers.
• Designed different Data Warehouse techniques like Star-Schema and Snow-Flake schema.
• Developed and supported Extraction, Transformation and Load process (ETL) using SQL Server ETL tool to populate the tables in Data warehouse and Data marts.
• Backup and recovery, performance tuning.
• Generated the periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Created complex Stored Procedures, triggers, cursors, tables, and views and otherSQLjoins and statements for applications by using T-SQL.
• Responsible for developing and deploying reports using SQL Server Reporting Services (SSRS).
• Responsible for creating stored procedures and SSIS packages as part of the ETL process to populate the data marts.
• Developed and enhanced ETL using master and child SSIS packages using control flow and data flow functions, passing on parameters on audit table to sync daily loads from the OLTP.
• Created SSIS packages and used Bulk Copy Program (BCP) to get data from various sources (Oracle, MySQL).

Environment: MS SQL Server 2008r2, Windows Server 2008, SSIS, SSRS and SSAS, BIDS 2008, Visual Studio 2010, SAN storage systems.

Confidential

SQL Server Developer (SSIS, SSRS)

Responsibilities:

• Installed and configured SQL Server 2008 on Development, Stage and Production Servers.
• Created SSIS packages for extracting data from different Legacy systems with special emphasis on data cleaning and error handling while loading the data.
• Automation of monitoring all the failed jobs in the database using SSIS and SQL mail.
• Developed and enhanced ETL using master and child SSIS packages using control flow and data flow functions, passing on parameters on audit table to sync daily loads from the OLTP.
• Transformation of data from one server to other servers using tools like bulk copy program (BCP), SSIS, data conversions from legacy systems to SQL server.
• Designed and deployed different types of reports like Chart, Matrix, List and others depending upon requirements by using SQL Server Reporting Services (SSRS).
• Write all stored procedures and functions and created the reports (SSRS).
• Making a Report as per user requirement using MS SQL Server Reporting Services (SSRS)

Environment: SQL Server 2008r2, SQL Server Reporting Services, Windows Server 2008, Visual Studio 2008.

Confidential, Miami, FL

SQL Developer

Responsibilities:

• Developed Databases and created indexes, Views, complex Stored Procedures, user defined functions, cursors, derived tables, and Triggers to facilitate efficient data manipulation and data consistency.
• Expert in T-SQL and performed most of the SQL Server Enterprise Manager and Management Studio functionality using T-SQL Scripts and Batches.
• Expert in writing complex SQL queries involving multiple tables inner and outer joins.
• Expert in optimizing the queries by creating various clustered, non-clustered indexes and indexed views.
• Involved in Planning, Defining and Designing data warehouse using MS Visio on business requirement and provided documentation.
• Tuning queries which are running slow using Profiler.
• Maintaining the database systems which include ensuring successful backups, resolving system issues, monitoring success and failure of automated jobs, monitor system availability etc.
• Wrote T-SQL queries, Store Procedures and used them to build packages.
• Excellent in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), Bulk Insert, BCP.

Environment: SQL Server 2005/2008, SQL Server Integration Services (SSIS), Visual Studio 2008/2005.