SUMMARY:

• Around 9 years of IT Professional experience in Development, Client Analysis, Database Design and Implementation using SQL Server.
• Experience in Design, Development, Implementation and Maintenance of Data warehouse applications as an ETL Developer in MS SQL Server as well as tools like SQL Server BI Tools (SSIS, SSRS& SSAS) in domains Banking, Insurance, Medical, Automation and Financial services.
• Extracted data into Data Warehouse Facts and Dimensions tables using SQL SERVER Integrated Services (DTS/SSIS).
• Very good experience and knowledge on SCD Types (Type1, Type2) and Change Data Capture.
• Exposure in Data Modeling using Star/Snowflake Schema Design, Data Marts, Relational and Dimensional Data Modeling, Fact and Dimensional tables, Physical and Logical data modeling using Erwin.
• Experience in Microsoft SQL 2012 Server migration from SQL Server Integration Service (SSIS), Crystal Reports and Reporting Service (SSRS).
• Expertise in High Level Design of ETL SSIS Packages for integrating data from sources (Excel, CSV, flat file, Text Format Data).
• Expert in Designing SSIS Packages to Extract, Transform and Load (ETL)/ DTS data into the data warehouse from heterogeneous databases such as Oracle, DB2, MS Access.
• Expert in migrating the DTS Packages to SSIS Packages by using Package Migration Wizard.
• Proficient in using T - SQL for creating Stored Procedures, Tables, Views, Indexes, SQL joins and performance-based query writing.
• Expert in Creating, Implementing, Configuring and deploying the SSIS Packages from one server to other.
• Experience to assist client in on boarding various application server on AWS Cloud and VMware Private Cloud.
• Good understanding and experience in common development models such as Agile, Scrum.
• Design complex solutions which integrate AWS cloud, on premise physical and Virtual server, EC2, S3 storage, networking and security.
• Extensively used tools like SQL Profiler, SQL Analyzer and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Expert in database backup, restore, Database mirroring and log shipping and implemented replication as high availability techniques.
• Expert in Unit Testing, Root Cause Analysis, Problem Management and Performance Tuning.
• Extensively used repositories Team Foundation Server (TFS) and SUBVERSION (SVN).
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
• Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.
• Excellent experience in designing and developing Reporting System using Business Objects.
• Well versed in Normalization/Demoralization techniques for optimum performance in relational and dimensional database environments.
• Hands on experience in creating indexed Views, Complex Stored Procedures, Functions, Triggers, CTE's to assist efficient data manipulation and data consistency and used DDL, DML commands for various business applications.
• Hands on experience working with SSIS, for ETL Process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Created SSIS packages with complicated transformations like Lookup, Derived Column, Condition Split, Multicast, Sort, Union All, Cache Transform, and Conditional Split, Fuzzy Look-ups, Checksum, Conditional Splits and Event Handlers, Error Handlers etc.
• Great Expertise in event handlers, Package Configurations, Logging, and Check points, Package Securities and User Defined Variables for SSIS Packages.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Created stored procedure for generating reports using SQL Server Reporting Services (SSRS).
• BI Integration with SharePoint like Power View, Power Pivot and Power Query, Excel Service, and Reporting service.
• Developed several PL/SQL Batch programs implementing transaction management using oracle features like SAVEPOINT, Rollback and Autonomous transaction on UNIX.
• Excellent hands on experience in creating groups, hierarchies and measures, KPIs.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.

TECHNICAL SKILLS:

Reporting Tools: SQL Profiler, Query Analyzer, SQL Server Management Studio, DTS, SSRS, Share point, Business Objects XI, Crystal Enterprise Reports, Tableau.

Tools: Erwin, Data stage, Toad, Win SQL.

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005/2012, Teradata.

Operating Systems: Windows 2010/2007/2005/NT/XP, MS-DOS, Linux

Languages: C, T-SQL, SQL,PL/SQL, SAS

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

MS SQL Developer /SSIS DEVELOPER

Responsibilities:

• Involved in all the phases of SDLC.
• Developed Data warehouse logical and physical data model using Erwin tool.
• Built Star Schema data model DW.
• Built SSIS packages to Load data from source systems to DW.
• Built SSIS packages for Dimension and fact tables.
• Depending on the size of the data in Dimensions handled Type 2 Slowly changing dimension using MERGE statement or the lookup component.
• Loaded Fact table with Millions of data by partitioning and loading the fact table using Meta data columns.
• Designed SSIS packages to handle both Full and Incremental Data load.
• Designed Customized logging along Error handling.
• Used Staging tables to cleanse the data and also to transform data wherever required.
• Deployed SSIS package to different environments and scheduled the packages using SQL Server agent job and monitored the deployed packages on the production server.
• Tuned the Performance of the SSIS packages by avoid the Blocking transformation, by configuring the Default Buffer Size and Default Buffer Max Rows, by using Column Store index wherever necessary.
• Audited each and every data load.
• Production Support for deployed SSIS packages.
• Developed SSRS reports as per the business requirements.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Developed various operational Drill-through and Drill-down reports using SSRS.
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.
• Worked Business Data Catalog to display the sale report data.
• Developed Reports for business end users using Report Builder with updating Statistics.
• Created Master package to call all the child packages using Execute Package Task.
• Used Sequence container to execute the packages in order Dimension are executed first then followed by Fact.
• Used File System task to Archive the loaded files.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Developed different kind of reports such a Drill-through and Drill-down, Sub Reports, Charts, Matrix reports, Linked reports.

Environment: SQL SERVER 2008 R2, 2012 R2, 2014, Teradata, Teradata SQL Assistant, Visual Studio 2010, 2012, 2013, ERWIN TOOL 9.0, VB.NET, ASP.NET, ADO.NET, Tableau, SSIS, SSRS, MS Office 2013, MS Visio 2010, MS Access 2007

Confidential

SQL Server/SSIS Developer

Responsibilities:

• Recommend and develop continuous improvements to processes that impact interchange data ingestion and maintenance
• Understand AAP functions and relationship of each of the data process and maintenance operations teams
• Maintain interchange database integrity across multiple platforms, including SQL Server 2012 and Oracle 11g.
• Design and implement data warehouses by creating table/tables in SQL Server 2012 and populating it with several other tables to create the warehouse. Then use SSIS to perform the ETL and automate the process from that point forward.
• Develop automation processes using SQL Server Integration Services (SSIS) 2012, T-SQL and other tools that assist team members in acquiring, processing, or finding accurate interchange information.
• Develop and maintain appropriate documentation as required
• Prepare and present periodic progress reports to identified stakeholders of the process
• Develop/conduct training on new/changed processes as directed by department manager
• Provide subject matter expertise on the interchange data processes for relevant initiatives and stake holders
• Work closely with the Merchandising Team to ensure complete and accurate interchange data is collected from Vendors and other relevant sources.
• Data Governance Analyst
• Create reports using ODBC and Oracle based database connections.
• Create scripts that will automate queries so they can be scheduled and emailed to the end user with no human interaction.
• Create Applications with Visual Studio 2015, publish and deploy to other platforms for the end users.
• Created a script that will reformat an XML file, have it parceled out into Access for data extraction and to validations.
• Report generation using multiple tools such as SQL Developer, MS Access, and VBScript.
• Create data validation tools to monitor and track progress of data, ensuring consistency throughout the downstream systems.
• Utilize multiple scripting technologies to automate manual tasks to increase efficiency.
• Data manipulation required to synchronize multiple, incompatible databases.
• Merchandising Specialist
• Access query creation for running reports that are tailor made for the individual or for my own personal usage.
• Oracle SQL developer to create and run reports from Oracle Retek Merchandising System.
• Vendor Onboarding from direct communication over phone with vendors through the skuing process.
• Oracle Retek Merchandising System maintenance from item setup, supersession implementation, and maintenance updates. This involves all aspects to item implantation from start to finish.
• Store creation in Oracle Retek Merchandising System and store information updates when needed.
• New Number Announcement query creation in order to pull information from ODBC to populate New Number Announcement forms for CARQUEST.
• Proficient in Stibo Systems maintenance and item implementation, introduction, and skuing processes. Create image files to backup larger amounts of data via DVD, Blu-ray, or external or internal hard drive configurations.
• Ensure digital assets submitted by the vendor follow Confidential guidelines and specifications
• Run data compliance reports to determine the accuracy of digital assets.
• Communicate with vendors to ensure compliance with digital assets (images) which in turn helped to build strong working relationships.
• Trouble shooting issues that may explain why vendors are not compliant.
• Setup new vendor folders for Stibo Systems and create the naming convention for Sterling Integrator folders.

Environment: SQL Server 2008/2005, Oracle 9i, MS .NET Framework, MS Visio, MS-Office 2007, HTML, XML, VB.NET, SQL Profiler, Windows 2003 Server, TFS /Visual source safe(VSS).

Confidential, Boston, MA

Senior SQL/SSIS Developer

Responsibilities:

• Involved in business requirement gathering from the end users and convert into Technical aspects by providing optimal solutions.
• Involved into multiple projects, Migration from MS access DB to SQL Server, upgrading from SQL server 2008 to 2012 including SSIS packages and SSRS reports. Performed GAP analysis for building data mart, involving into housing goal scoring and reporting projects.
• Involved in maintenance of existing .Net windows based WPF application by providing various scoring and reports utilizing .Net code behind.
• Responsible for database, ETL development activities and handling production support for the operational data loads utilizing SQL Server, Oracle, SSIS and SQL Agent.
• Responsible for designing complex SSIS packages for performing ETL operations as per the need and scheduling the jobs on the agent using configurations.
• Experience in extracting data from heterogeneous systems like csv, Oracle, Excel, XML, text files etc. for performing business operations and applying rules.
• Responsible for creating and maintaining various database objects like Stored Procedures, Views, functions, Triggers and Constraints etc. to meet the needs.
• Responsible for utilizing various control flow tasks, data flow elements, event handling, logging, configuring, deploying and scheduling SSIS packages at various stages in different environments.
• Experience In creating scoring and reports for reporting purpose.
• Experience in writing excel macro's for performing operations as per the need using VB.Net and providing formatted reports out of it.
• Responsible for performance enhancements using optimization techniques such as Normalization, Indexing and Transaction Isolation levels.
• Responsible for implement Unit testing and performance improvement purposes.
• Experience in .NET/C# application development web service enhancements and internal requirements.
• Developed DAOs (Data Access Objects) and SQL queries to support system functionality.
• Modified web services to interact with the other applications and exposed them using SOAP and HTTP.
• Used Hibernate, object/relational-mapping (ORM) solution, technique of mapping data representation from MVC model to Oracle Relational data model with SQL-based schema
• Responsible for creating and maintaining the documentation for implementation and for future changes.

Environment: MS-SQL Server 2012/2008R2 Enterprise Manager, Oracle SQL Developer, MS-Access 2010/2007, TOAD, SAS, SharePoint Server 2010, XML, MS Office 2013, MS Visio 2010, VB.Net, C#. Net, Visual Studio 2013/2010/2008, Windows Server 2008, TIDAL, SQL CMD Utility TFS.

Confidential, Boston, MA

SQL Developer

Responsibilities:

• Applied Normalization rules in designing the database.
• Created Entity relationship diagrams ER-Diagrams, function relationship diagram, Dataflow Diagrams and enforced all referential integrity constraints.
• Developed database objects like tables, views, stored procedures, indexes etc.
• Tuned SQL statements using views and stored procedures.
• Rebuilding the indexes at regular intervals better performance.
• Wrote various stored procedures for the purpose of application development.
• Design and implemented data access stored procedures and triggers for automating tasks.
• Extensively used joins and sub-queries to simplify complex queries involving multiple tables.
• Responsible for creating DTS packages and scheduling packages
• Managing of users including creation/alteration, grant of system/db roles and permissions on various database objects
• Created SSIS packages for File Transfer from one location to the other using FTP task.
• Extracted data from various sources like SQL Server 2008/2012, Oracle, .CSV, Excel and Text file from Client servers and through FTP.
• Handled Performance Tuning and Optimization on SSIS and MDX, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.
• Created Data-driven Packages in SSIS 2012 as part of the automating the process for the Referral Process.
• The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Reviewed & Tested packages, fixing bugs (if any) using SQL 2005 Business Intelligence Development Studio.
• Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.
• Involved to planning and designing SSAS 2012 Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.
• Involved in Staging Partitions and Usage Based Optimization (UBO) mechanisms for SSAS 2012 and 2008 OLAP databases.
• Involved in Tabular Data warehouse and DAX operations for SSAS 2012 and 2008 OLAP databases.
• Involved in performing Audits and recovery operations of SSAS objects.
• Assess the risks and recommend/ install service packs or hot fixes when needed.

Environments: SQL SERVER 2000, DTS packages, Crystal Reports 6.0, Microsoft Visual Basic 6.0 and windows 2000/2003.