PROFFESIONAL SUMMARY:

• Around 7+ experience in IT having experience in Database Design, Development & Support of MS SQL Server for Production/development.
• Proficient in Relational Database Management Systems (RDBMS).
• Expertise in Transact - SQL (DDL, DML, DCL) and in Design and Normalization of the database tables.
• Experience in implementing business logic using Triggers, Indexes, Views and Stored procedures.
• Extensive Knowledge of advance query concepts (e.g. group by, having clause, union so on).
• Experience with tools like SQL Server management studio and SQL Server 2014/2012/2008/2005 integration (SSIS) and reporting services(SSRS).
• Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging.
• Proficient in Tuning T-SQL queries to improve the database performance and availability.
• Experienced hands in Query tuning and performance tuning.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Primary and Foreign Keys.
• Expertise in creating Packages using SQL Server Integration Services (SSIS).
• Experience creating Public Objects (Reports, Dashboards. Filter, Prompts) and Schema Objects in MicroStrategy
• Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.

TECHNICAL SKILLS:

SQL Server Tools: SSRS, SSIS, SSAS, Enterprise Manager, Profiler, Query Analyzer

RDBMS: MS SQL Server 2008/2012, MS Access, Teradata

Programming Languages: C, C++, Java, SQL, T-SQL, PL-SQL

Internet Technologies: XML. HTML

Productivity Applications: MS Word, Excel, Access

Reporting Tools: MicroStrategy 10.1/9.4, SSRS

PROFESSIONAL EXPERIENCE:

Confidential, TN

SQL Server (T-SQL, SSIS)/MicroStrategy Developer

Responsibilities:

• Interacted with Business Analysts, Business Users and Managers for Gathering, Analyzing, Documenting Business Requirements, Functional Requirements and Data Specifications.
• ETL, data profiling, data quality and clean ups for SSIS packages.
• Worked with installing, designing and managing MS SQL Server 2012.
• Creating and managing schema objects such as tables, views, indexes, stored procedures, and maintaining Referential Integrity.
• Created SSIS packages to populate data from various data sources.
• Created packages using SSIS for data extraction from Flat Files, Excel Files, AS400 and OLEDB to SQL Server.
• Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
• Involved in Creating Schema Objects (facts, attributes, hierarchies, Transformation) and application objects (filters, prompts, metrics, consolidations, custom groups, reports) needed to create the Micro strategy objects necessary for the deliverable.
• Created transformational metrics (Sales, Sales Target, Market Share, and Growth) to compare monthly, quarterly and annual sales.
• Extensively worked in developing Metrics, Derived metrics, Compound metrics and Filters for complex reports.
• Creating Dash Board Reports to view personalized reports based on user requirements
• Involved in Developing Reports by using Free Hand SQL Queries in Micro Strategy Desktop.
• Used Apply Simple and Apply Comparison functions to develop complex Filters and Transformations.
• Create a test plan, perform unit test and send the test plan along with the files generated for QA.

Environment: MS SQL Server 2012, SQL Server Integration Services, Visual Studio, T- SQL, MicroStrategy 9.2/9.4 (Desktop, Architect, Web, OLAP Services, Administration)

Confidential, MD

SQL Server(ETL/SSIS)/ MicroStrategy Developer

Responsibilities:

• Involved in business requirements analysis and documentation.
• Build efficient SSIS packages for processing fact and dimension tables with complex Transforms and type 1 and type 2 slowly changing dimensions.
• Created mapping documents to find out the missing attributes for the ETL process.
• Used the row count transformation and event handlers control flow to populate the special Log tables with high level SSIS package execution results.
• Creating source and target table definitions using SSIS. Source data was extracted from Flat files, SQL Server and DB2 Database.
• Created SQL Jobs to schedule SSIS Packages in SQL Server Agent.
• Worked with various tasks of SSIS include Transform Data Task, Execute SQL Task, Active Script Task etc.
• Scheduled the SSIS packages to run at different intervals to load the data.
• Created Reports and Dashboards in MicroStrategy
• Created different kind of Dashboards like Sales Dashboard, Forecast Dashboard and Write Back Dashboard.
• Unit Testing and QA for ETL and MicroStrategy Reporting.

Environment: MS SQL Server 2012, SQL Server Integration Services, Visual Studio, T- SQL, ETL, MS Excel 2013, MS Visio, Visual Studio, MicroStrategy 9.4

Confidential, NC

SQL Server(ETL/SSIS) Developer

Responsibilities:

• Implementation of MS SQL Server 2008/2005 Management studio to create Complex Stored Procedures, User Defined Functions (UDFs) Views using T-SQL to evaluate result for the reports.
• Responsible for installation and Configuration of SQL Server 2005 and 2008 database.
• Created Complex ETL Packages using SSIS to extract data from Source to staging tables and Dimension and Fact tables with incremental load.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into SQL Server Database.
• Developed, deployed, and monitored SSIS Packages.
• Performed operations like Data reconciliation, validation and error handling after Extracting data into SQL Server.
• Created SSIS packages for File Transfer from one location to the other using FTP task.
• Involved in performance tuning of TSQL queries and Stored Procedures.
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Upgrade of SSIS Packages from
• Wrote complex T-SQL Queries to Retrieve Data from Tables for Business Users.

Environment: MS SQL Server 2005/2018, SQL Server Integration Services, Visual Studio, T- SQL, ETL, MS Excel 2013, MS Visio, Visual Studio, Oracle Exadata.