SUMMARY:

• Have over five years of focused experiences in IT industry in various fields like financial and telecom domain.
• Extensive experiences in Confidential SQL Server Business Intelligence (BI) and data warehouse design, analysis, modeling, development, administration, implementation, trouble shooting and quality management.
• Comprehensive experience as senior MS BI and SSIS ETL developer; proficient in designing the logical and physical model of the enterprise level databases.
• Have impeccable communication and interpersonal skills and an exceptional team player.

TECHNICAL SKILLS:

Database: M icrosoft SQL Server 2008R 2/2012/2014/2016

Language s: SQL, C#/ Java/Python, PowerShell

Tools: Confidential SSMS/ Visual Studio/SharePoint /Erwin/Red Gate

Developing: JIRA /Rally /Subversion/TFS/ GIT

Confidential BI Stack: T - SQL/SSIS/ SSRS/SSAS, BISM, Power View, Power Pivot

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Senior Microsoft SQL and BI Developer (SSIS)

Responsibilities:

• Developed new and customized existing major reports using Confidential Reporting Services for senior management.
• Worked on team and individual projects to deliver secure, robust BI solutions that helped improve efficiency, data integrity and customer satisfaction.
• Maintained database performance, created advanced reports, Dashboards (SharePoint 2013), designed ETL package with SSIS, write stored procedures and created ad hoc reports using Excel.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.
• Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Slowly Changing Dimension and more. Performed ETL mappings using MS SQL Server Integration Services.
• Effectively cooperated with team members to gather and consolidate data manually when it is not available systematically.
• Worked closely with various areas within the department to gather requirements, understand and document new data sources and provide ad hoc solutions to management as needed.
• Utilized the Agile Scrum software development principles and experiences to develop within the full life-cycle of the mission critical production application.
• Investigate application anomalies to determine root cause. Resolve data issues per business needs. Perform ad hoc queries as needed. Develop and maintain general and online program reports.
• Maintained and enhanced the existing Data Warehouse, exports and reports; developed vendor and client exports that meet provided specifications.
• Performed quality checks on reports and exports to ensure exceptional quality; monitored jobs and transfer queues to ensure they were functioning as expected.
• Created unit test cases and technical documentation, performed detailed code reviews, and created automated build and deployment scripts.

Microsoft ETL Developer (SSIS)

Responsibilities:

• Working as the key role in maintaining and enhancing key back office financial applications originally developed using SQL Server2012.
• Participated in the full life-cycle development process from definition and design to production delivery.
• Created complex analytic queries on very huge data sets; developed T-SQL stored procedures, triggers and user-defined functions.
• Developed complex stored procedure, views and user-defined functions on SQL Server (2008R2 and 2012); identified weaknesses in T-SQL code and then improved those weaknesses for future release.
• Utilized the Agile Scrum software development principles and experiences to develop within the full life-cycle of the mission critical production application.
• Analyzed data requirements for the business applications; Developed data models and planned data migration/conversion strategies for internal and externally hosted applications.
• Maintained and enhanced the existing Data Warehouse, exports and reports; developed vendor and client exports that meet provided specifications.
• Performed quality checks on reports and exports to ensure exceptional quality; monitored jobs and transfer queues to ensure they were functioning as expected.
• Migrated the existing MS Access reports to SSIS/SSRS and developed new SSIS/SSRS packages to meet business needs.
• Provided business users the data required for metrics and analysis; created and maintained documentations for all related projects.

Microsoft SQL Developer

Responsibilities:

• Worked as a developer in creating Complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T SQL code and SQL joins for applications.
• Created and managed schema objects such as Tables, Views, Clusters, Indexes, Procedures, Triggers and maintained Referential Integrity.
• Monitoring all activities of the Server by monitoring the daily SQL jobs, SQL Server error logs and Windows error logs.
• Assemble and convert user requirements into standard reporting solution and customize specific user requests when necessary.
• Investigate and optimize reporting system performance by optimizing queries, and using report cache and snapshot.
• Performed tune to optimize SQL queries using SQL profiler and query analyzer. Involved in performance tuning of the database and T-SQL queries using Explain Plan. Created Indexes, Constraints and Rules on database objects.
• Create stored procedures and user defines functions to supports efficient data storage and manipulation. Handling database objects with Enterprise Manager. Provided Technical Documentation for future enhancements.
• Schedule and manage daily / weekly / monthly sales and operational reports based on the business requirements.