SUMMARY:

• Over all 12+ years of strong IT industry experience as a Business Intelligence Developer, Requirement analysis/ Design, Development, Testing, Support analyst in Data Warehousing solutions, ETL and Business Intelligence solutions.
• Supporting those operations by Software systems using various technologies (MS SQL Server 2005/2008 R2/2012, ETL - MSBI).
• Expertise in Microsoft Technologies (SSIS, SSRS, SSAS and SQL Server 2005/2008/2012 ) and other Databases (Oracle, DB2, Teradata).
• Very good expert knowledge in MS SQL Server Development and TSQL.
• Experience with full development cycle of a Data Warehouse, including requirements gathering, design, implementation, and maintenance.
• Experience in Agile Project and Erwin Data Model, Embarcadero DA, Data mapping, Tableau reporting.
• Very good experience in Dimensional model with MDX, DAX Queries and Power BI Visualization tool.
• Worked in Health care pharmacy and retail domain development projects.
• Experience in coding and supporting the .NET applications.

TECHNICAL SKILLS:

Databases: SQL SERVER 2008/2012/2014, MS-Access and MY SQL

Programming: VB, C3, C, C++ & SQL

Operating System: Windows 2008/2012 R2 Advanced Server, NT & Windows 9x, Linux

Tools: Backup Utility, SQL LiteSpeed, Excel Power View

Network Topologies: TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP

PROFESSIONAL EXPERIENCE:

Confidential, Jacksonville, FL

Senior MSBI/ SQL Developer

Responsibilities:

• Involved in the analysis of the requirements and gathering requirements for closed loop project.
• Involved in creating tables and their relationships in the data warehouse.
• Development, Deploy and support in SSIS and SSRS.
• Developed large number of standard and customized reports using SSRS for data feeds and for Reports on server.
• Developed Dynamic Report Engine for creating the customized reports in SSRS.
• Involved in creating Dynamic Stored Procedures and views.
• Understand the business needs and convert into the Data Models using Embarcadero Data modelling, ODS Table design, DB Objects.
• Involved in analyzing and gathering the requirements for Row level Security and Role based security.
• Need to perform SSRS development, deployments and subscription for business users. Create Various SSRS report models ( Drill Down, Sub Reports, Parameterized Reports )
• Integration between Salesforce and ODS.
• Writing Stored procedures, Views, Triggers for ad hoc related reports/Dashboards.
• Working closely with product owner, understanding requirements and converting into Reports.
• Implemented Row level security and Role based Security in the Standard Reports.
• Involved in creating the tree view folder structure in the application using C#.net to handle different reports.
• Involved in Creating and Testing the SSIS packages developed for security.
• Involved in creating SSIS packages to migrate large amounts of data.
• Involved in using SSAS data sources in SSRS reports.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Involved in performance tuning of queries for query efficiency.

Confidential, New York, NY

SQL / MSBI Lead

Responsibilities:

• Involved in database development using stored procedures, triggers, views and cursors.
• Development, Deploy and support in ETL projects for large-scale Data Warehouse using SSIS (Integration between SQL, DB2, oracle,PostgreSQL,XML, MySQLandHadoop) SSAS and SSRS.
• Used the Object Oriented Analysis and Design specification Unified Modeling Language (UML) for visualizing, specifying, constructing, and documenting data.
• Followed the Agile Methodology in the SDLC.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Wrote efficient stored procedures for the optimal performance of the system
• Monitored performance and optimized SQL queries for maximum efficiency.
• Responsible for Creating and Modifying T-SQL stored procedures/triggers for validating the integrity of the data
• Created indexed views, and appropriate indexes to reduce the running time for complex queries
• To keep track of data manipulations using Audit functionalities.
• Generated custom and parameterized reports using SSRS
• Created reports that call sub reports in SSRS
• Configuration and Deployment of all the Reports(RDL,RDS) across various SDLC environments
• The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Multicast and Data Conversion.
• Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs
• Responsible for creating datasets using T-SQL and Stored Procedures and also involved in Data visualization.
• Created several packages in SSIS.
• Custom components for SSIS packages were written in VB.net.
• Scheduled the packages to keep extracting the data from OLTP at specific time intervals
• Used various transformation tasks to create ETL packages for data conversion.
• Responsible for rebuilding the indexes and tables as part of performance tuning
• Used SQL Server Agent for scheduling jobs and alerts
• Performed Query optimization & Performance Tuning
• Optimized queries using SQL Profiler and Database engine tuning advisor

Confidential, Shawnee Mission, KS

SQL / BI Developer

Responsibilities:

• Created Stored procedures, Triggers and functions.
• Resolved deadlock issues of the application using SQL Profiler.
• Worked with developers to tune the queries, run scripts and move the database production to development servers.
• Configured and maintained Snapshot and Transactional replication for 3 environments.
• Troubleshooting replication errors and handling logs.
• Created logical and physical data modeling for development database using ERWIN tool.
• Created SSIS packages for transforming data.
• Created schema objects, rules and granted roles to the users.
• Worked and coordinated with developers in writing and tuning new stored procedures.
• Worked on DTS packages to import the data from Oracle, Access and text files.
• Responsible for stored procedures optimization, performance tuning and index tuning.
• Configured RAID (Redundant Array of Independent Disks) levels.
• Automated processes using SQL Server Jobs.
• Set up backups for the newly created databases.
• Scheduled transfer of backups and log files to different servers.
• Provided a support for data issues and given appropriate solutions.
• Provided training to development team on performance tuning and SQL best practices for enhancing application output.
• Created tabular and matrix Reports using SSRS.
• Created the documentation for SQL server and service packs installations.

Confidential

SQL Developer

Responsibilities:

• Set up new SQL Servers 2000 and configuring the required users.
• Restored and copied Production Database.
• Responsible for MS SQL Server Installation and configuration as well as applying service packs and hot fixes.
• Provided User Access at all levels for both the network and the SQL Server databases; configured and audited SQL Server security; managed SQL Server logins and user accounts/passwords; managed database object permissions.
• Involved in creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers, Rules and Defaults.

Confidential

SQL Developer

Responsibilities:

• Involved in gathering of all the requirements for the project. Implemented the SDLC concept.
• Used Rational Rose for UML diagrams and ER diagrams.
• Developed a web application using C#.net and ASP.net.
• Created user controls for login pages and also used validation controls.
• Provided authorization to control user access to application features.
• ADO.net data accessing using stored procedures.
• Created tables and wrote stored procedures using SQL Server 2000.
• Developed web services and consumed them in the project.
• Created Reports and designed graphical representation of analyzed data.
• Designed screen shots for the frontend users and also handled the backend.
• Involved in checking of coding standards and code review for application code.

Confidential

Software Engineer

Responsibilities:

• Designed and implemented a system to convert MapReduce actions into Spark actions and facilitate the customer to choose between execution engines
• Performance testing of Sparkified actions
• Point person in the team for managing QA deliverables and documentation