SUMMARY

• Over 9+ years of strong experience in the IT industry as a SQL Server Developer (SSIS, SSRS, SSAS) with sound business analysis skills.
• Experience with the 32bit, 64 - bit Microsoft SQL SERVER as Developer in OLTP and OLAP with Production, Development and Testing in Clustered and Stand alone Server Environment.
• 5 years of experience in ETL process - SQL Server Integration Services (SSIS) and Data Transformation Services DTS.
• 5 years of experience in generating Reports (SSRS) in Business Intelligence Development Studio (BIDS).
• Experienced in all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Expertise in MS Office, Visio, Testing tools, Rational Unified Process (RUP), Unified Modeling Language (UML), Object Modeling, Rational RequisitePro and other web technologies.
• Extensive experience in MS SQL Server 2008/2005/2000, Business Intelligence in MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS) .
• Experienced in loading data into Netezza using NZLOAD utility.
• Experienced in loading data between Netezza tables using NZSQL utility.
• Performed Key Role in Logical and Physical Database design and development, Normalization and Data modeling using Erwin and SQL Server Enterprise manager.
• Experience in Software Development Life Cycle (SDLC), Analyzing and Designing systems using Structured Methodologies (ERD, DFD) along with extensive knowledge of Relational Database Management Systems with in-depth of T-SQL.
• Expertise in Extracting, Transformation and Loading (ETL) data using various tools including Bulk insert (BCP), Import/Export data and SQL server Integration Services.
• Involved in Database migrations from legacy systems, SQL server to Oracle and Netezza.
• Automated manual process with SQL Server Integration Services (SSIS) packages for import, export and bulk insert data with transformations from various data sources.
• Used all the major Control flow tasks in SQL Server Integration Services (SSIS) like …Containers (Forloop/ Foreach /Sequential ), File system task, Data flow task, Bulk Insert, FTP task, SMTP task, Exec SQL task, Exec Process Task, Exec package task etc…
• Used all the major Data Flow Transformations ( Aggregate, character map, condition split, data conversion, derived column, Data Conversion, Lookup, Fuzzy lookup, Merge, Merge Join, Multicast, OLEDB command, Slowly changing Dimension, Sort, Union All, Row count)
• Scripted VB.net in the script task for data conversions in SQL Server Integration services (SSIS) packages.
• Involved in designing and developing more than 100+ enterprise reports (SQL Server Reporting Services (SSRS)/Business Objects).
• Experienced in writing Parameterized queries for generating Tabular reports, Formatting report layout, sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SQL Server Reporting Services (SSRS) 2005/2008.
• Expertise in creating complex reports like Drill Down and Sub Reports using SQL Server Reporting Services (SSRS).
• Experienced in implementing Conditional Formatting, Interactive Sorting, Grouping and Filtering using SQL Server Reporting Services (SSRS).
• Expertise in handling the Datasets using complex queries and stored procedures for generating reports using SQL Server Reporting Services (SSRS).
• Experience working with UC4 automation tool for scheduling Jobs.
• Hands on experience working with Microsoft Dynamics AX ERP system. Acquainted with various functional areas like Sales, Procurement, and Financial Management.
• Acquainted with Oracle 10g.
• Acquainted with Visual source safe (VSS) 2005 and Team Foundation Server (TFS) as part of version control for Database Objects.
• Excellent written and oral communication skills with a results-oriented attitude. Good in Collecting, Analyzing and Interpreting Data in an organized way. Versatile in working as an individual and also as part of a team. Proficient with various computer operating systems.
• Proactive team player with demonstrated problem solving and analytical reasoning abilities.
• Excellent analytical and problem solving skills, with strong communication skills and team player.

TECHNICAL SKILLS

Databases: MS SQL Server 2008/ 2005/ 2000, Aginity Workbench for Netezza, Oracle 10g, IBM DB2

ETL Tools: SSIS 2008/ 2005

Reporting Tools: SSRS 2008/ 2005, Crystal Reports

Web Technologies & Tools: C, UML version 2.0, MS Dynamics ERP System, Tidal jobs

Methodologies: RUP, UML

Version Control Systems: Rational Clear Case, TFS 2010, TFS 2008, Visual Source Safe 2005, SQL DB

Project Management Tools: Microsoft Visio, Rational Clear Quest, Requisite Pro

Other Application Tools: HTML, DHTML, Visual Basic, Core FTP

Operating Systems: MS Windows, Red hat Linux, Unix, MAC OS

ERP System: Microsoft Dynamics AX

PROFESSIONAL EXPERIENCE

Confidential, Columbia, MD

Netezza Developer/ MS SQL BI Developer

Responsibilities

• Participating in User meetings, gathering requirements and translating user inputs into Technical Specification documents.
• Involved in full SDLC from gathering requirements, analysis, design, modeling, development, testing and implementation needed for loading and updating the warehouse.
• Worked closely with the Project Leads to understand and analyze the requirement.
• Involved in loading the data into Netezza from legacy systems and flat files using complex UNIX scripts.
• Involved in building the ETL architecture and Source to Target mapping to load data into Relational DB’s as well as ODS’s..
• Analyzed the Functional Specs provided by the architect and created Technical Specs documents for all the mappings.
• Design, develop, document and deploy solutions to populate the Data Warehouse from source to target.
• Extensively used Aginity Netezza work bench to perform various DML, DDL...etc operations on Netezza database.
• Used BCP Utility to extract data and create flat files for big volume Tables.
• Used Core FTP to move files from a storage device to a FTP location from where these files were loaded to Netezza Database.
• Extensively used NZSQL & NZLOAD utilities to load the data into Netezza database.
• Involved in production on call support to fix issues and helping out from the system failures.
• Used SSIS to create ETL packages to validate, extract, transform and load data to pull data from Source servers to staging database and then to Netezza Database and DB2 Databases.
• Used Informatica to execute shell scripts to load data from Flat files to Netzza Databases.
• Implementing and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables, Check Points and Expressions for SSIS Packages.
• Developed High Level Design of SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, Flat File, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union All.
• Created audit events for master and child packages to track the status of the package execution.
• Involved in Modifying existing packages for better Performance.
• Worked with XML Data import and export process.
• Formatted XML data using Extensible Stylesheet Language (XSL).
• Generated Reports on XML Data using XSLT
• Used SQL DB source Control Tool for checking in New Database Objects and modified Database Objects under Version Control.

Environment: Netezza 7.0, Aginity work bench 2.1, PUTTY, UNIX, Core FTP, MS SQL Server 2008R2, MS SQL Server Integration Services (SSIS), Informatica, SQL DB (Version Control), Microsoft Visio.

Confidential, Lancaster, PA

MS SQL BI Developer

Responsibilities

• Extensively working on gathering Business Requirements and defining business rules.
• Analyzing the Business needs and the viability of converting requirements or business process into technical requirements and use them to create solutions.
• Involved in Requirements Gathering from Business Users, design and develop the work flows.
• Tasks included Defining Requirements, Design, Develop, Test, Implement and Maintain reports using SSRS Reports.
• Involved in creating, maintaining different SQL Server Objects such as Tables, Procedures, Functions, Views, CTE’s, Triggers etc. according to the Requirements.
• Implemented the Error handling in the Stored Procedures and SQL Objects and also modified already existing Stored Procedures, Triggers, Views, Indexes depending on the requirement.
• Involved in setting Coding Standards and Report Standards. This included creating Report Templates and defining development Standards. Changed existing Reports and Database Objects to confirm to current conventions.
• Developed Complex Stored Procedures and several Reports with consistent drill-down functionality including Drilldown reports, Summary Reports, Parameterized reports, Sub-reports, Master Detail Reports and Linked reports with multi value parameters for the analysis of Performance using SSRS and integrated into the web front end.
• Created user defined functions in SSRS and developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Enhancement of existing Reports and fixing the bugs if any.
• Created simple query filters, prompted filters and complex filters to restrict Data in Reports.
• Deploying and scheduling Reports/ Subscription using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Generated reports using SQL Server reporting Services 2005/2008 from OLTP and OLAP databases.
• Monitored and Tuned SQL server Database Performance and Query Analysis for optimizing report performance.
• Involved in Documentation, testing and implementing solutions using applicable SSIS and SSRS technologies.
• Involved in creating a Reports Requirement Document and also Data Dictionary to keep track of the Database Objects used for development of Reports.

Environment: MS SQL Server 2008R2, MS SQL Server Reporting Services (SSRS), SQL Compare, Microsoft Visio.

Confidential, - Solon, OH

MS SQL BI Developer

Responsibilities

• Experienced in participating meetings with business users to gather the requirements.
• Interacted with business users and collect the required information (BRD) for developing Business Rules Document which would become the basis for the Fulfillment Reconciliation Process.
• Involved in Creating End to End Traceability Matrix, Legends Documentation, for the entire
• Created User Training Manual which dealt with the entire Fulfillment Reconciliation Process.
• Created complex Stored Procedures, triggers, functions, cursors, tables, views and other SQL joins and statements for applications by using T-SQL.
• Perform daily database backup and restoration and monitor the performance of Database Server.
• Create joins and sub-queries for complex queries involving multiple tables.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Worked on DTS Package, DTS Import/Export wizard for transferring data from Database (Oracle and Text format data) to SQL Server.
• Explicitly used Pivot Transformation, Fuzzy lookup, Derived Columns, Term extraction, Condition split, aggregate, lookup, Execute SQL Task, Merge join etc for creating SSIS packages.
• Used SSIS control flow tasks like Loop Containers, FTP, Bulk insert, Transfer job task etc. and different data flow tasks like Derived Column, Fuzzy lookup, data conversion etc.
• Involved in creating packages for extracting and loading data from text file to SQL Server Database.
• Created SSIS 2008 to develop packages to load data from Text files, MS Excel files, Flat files into the SQL server database using Import and Export wizard, Bulk insert tasks etc.
• Used SSIS for (ETL) extraction, transformation and loading data from heterogeneous source systems.
• Involvement in defining scope for the Reconciliation Process and helping business in solving existing issues.
• Documenting the Process flows and flow chats with VISIO and MS-Word.
• Developing Timeliness Metrics and Weekly and Monthly Trending Reports by means of Graphical Representation/ Pictorial Representation of Data.
• Worked on creating Unit Test Cases for every stage in the Fulfillment Reconciliation Process.
• Extensive testing on the Performance of the Database Objects.
• Involved in Unit testing integrated testing and System testing.

Environment: MS SQL Server 2008R2, MS SQL Server Integration Services (SSIS), Visual Source Safe (VSS 2005), Microsoft Visio.

Confidential, - Greenville, N

MS SQL BI Developer

Responsibilities

• Worked extensively on Gathering requirements from the User for Creating Reports and delivering them as per the specification.
• Created Report Requirement Document for the Reports that were supposed to be developed.
• Worked on Defining the Coding Conventions and Standards for Development of new Database Objects.
• Laid out Specification/ Criteria’s for New Report Creation.
• Worked extensively in writing and debugging complex stored procedures, triggers, Inner Joins, Outer Joins,ViewsandUser-defined functions. Used SQL Server Management Studio for developing database objects.
• Created complex Stored Procedures for Drill Down and Drill through Reports
• Worked on creating complex reports like Drill down and Sub Reports using SQL Server Reporting Services.
• Worked on implementing Conditional Formatting, Interactive Sorting, Grouping and Filtering using SQL Server Reporting Services.
• Handled the Datasets using complex queries and stored procedures for generating reports using SQL Server Reporting Services (SSRS).
• Responsible for creating complex reports like Drill down and Sub Reports.
• Created ad-hoc queries from SQL Server databases for custom reporting needs.
• Created Tabular, List, Matrix, Charts, and Ad-hoc reports using SSRS.
• Used Bar Charts and Column Charts extensively as Pictorial Representation was needed for several Reports.
• Created Dynamic Data Source so that Reports could fetch Data from different Databases.
• Configured Report Server across different environment.
• Have experience working on BING Map Control and using Spatial Data.
• Used SSRS as a Reporting Platform to Source Data from Microsoft Dynamics AX 2012 ERP System.
• Acquainted with Sales and Procurement modules of Microsoft Dynamics AX 2012 ERP System.
• Created Templates for Reports that could be used for creating New Reports.
• Involved in Change Management Procedure and also in converting existing Reports as per the new standards using Dynamic Data Source.
• Configured the Properties in the Reports Project so that the Reports could be deployed from Visual Studio.
• Performing DBA functions, installing, configuring and supporting database systems.
• Reported all events and requirements through established reporting mechanisms in SSRS.
• Used Visual Source Safe (VSS) to keep all the Database Objects under Source Control.
• Fully supported change management procedures.
• Used SQL Compare to propagate Stored Procedures across different Databases.

  Environment: MS SQL Server 2008R2, MS SQL Server Reporting Services (SSRS), Microsoft Dynamics AX 2012, Visual Source Safe (VSS 2005), Microsoft Visio.

  Confidential, Pittsburgh, PA

  MS SQL Developer/BI Developer

  Responsibilities

  • Worked on getting the documentation and delivering it to functional specification document.
  • Worked with business representatives to gather report requirements and delivering the Reports as per the Specification. This involved frequent interaction with offshore team and also onshore team.
  • Worked extensively in writing and debugging complex stored procedures, triggers, Inner Joins, Outer Joins,ViewsandUser-defined functions. Used SQL Server Management Studio and also PL SQL Developer for developing database objects.
  • Involved in Designing, Developing and Testingof the ETL(Extract, Transformation and Load) strategyto populate thedatafrom various source systems feeds usingSSIS.
  • Responsible for coding SSIS processes to import data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB Sources.
  • Implemented SQL queries and stored procedures and validated code against designs.
  • Involved in Converting Crystal Reports to SQL Server Reporting Service.
  • Developed complex Stored Procedures and views to generate various Drill-through reports, Drill Down, Ad hoc reports, parameterized reports using SQL Server Reporting Services (SSRS).
  • Worked extensively to provide ad hoc queries to business users on a daily basis.
  • Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
  • Used SQL Profiler for debugging issue, performance tuning whenever necessary.
  • Generated on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
  • Dropped and recreated the indexes on tables for performance improvements. Tuned SQL queries using execution plan for better performance.
  • Worked on Migration the packages from DTS using SQL Server Integrating Services (SSIS) and also involved in testing and troubleshooting the errors as part of the migration process.
  • Used all the major Control flow tasks in SSIS like …Containers (foreach / sequential), File system task, Data flow task, Bulk Insert, FTP task, SMTP task, Exec SQL task, Exec Process Task, Exec package task etc…
  • Extensively worked on SQL Server Integrating Services (SSIS) for transferring data from Heterogeneous Database ( OLE DB, Excel, Flat file, Data reader for Teradata Tables ) to create Data Marts
  • Automated many manual ETL process using SQL Server Integrating Services (SSIS) and Supported with existing complex Production SQL Server Integrating Services (SSIS) Packages.
  • Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
  • Used C# .Net in SSIS Script Task.
  • Involved in the deployment of SQL Server Integrating Services (SSIS) packages on to the MSDB database.
  • Querying of source and target database for unit testing.
  • Monitored connections, locks andperformance of SQL server.
  • Used Team Foundation Server (TFS) to keep Database Objects under Source Control.
  • Designing and building data load procedures usingMS SQL Server.
  • Used TFS (Team Foundation Server) for keeping Database Objects under Source Control.
  • Performance:Troubleshoot system issues performance tuning using SQL Server Profiler and Database Engine Tuning Advisor for better performance.
  • Involvement in defining scope for new releases and helping business in solving existing issues.
  • Documenting the Projects and flow chats with VISIO and MS-Word.
  • Extensive testing on the Performance of the Stored Procedures.
  • Involved in Unit testing integrated testing and System testing.

  Environment: MS SQL Server 2008R2, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Crystal Reports Version 10, Oracle PL SQL Developer, XML, Team Foundation Server (TFS), Microsoft Visio.

  Confidential, Salem, NC

  MS SQL Developer/BI Developer

  Responsibilities

  • Contributed with documentation and delivered functional specification document. Assisted the Project Manager to develop both high-level and detailed application architecture to meet user requests and business needs.
  • Worked extensively in writing and debugging complex stored procedures, triggers, Inner Joins, Outer Joins,ViewsandUser-defined functions using SQL Server as well as PL SQL.
  • Involved in Designing, Developing and Testingof the ETL(Extract, Transformation and Load) strategyto populate theinsurance datafrom various source systems feeds usingSSIS.
  • Responsible for coding SSIS processes to import data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB Sources.
  • Implemented SQL queries and stored procedures and validated code against designs.
  • Used SSIS (Analysis Processing Task) for Processing SSAS Cubes and Updating Dimensions.
  • Configured the SSAS Cubes, using Analysis Procession task for Scheduled process.
  • Used Transfer Job Task and Execute SQL Server Agent Job Task in constructing SSIS packages.
  • Developed complex Stored Procedures and views to generate various Drill-through reports, Drill Down, Ad hoc reports, parameterized reports using SQL Server Reporting Services (SSRS).
  • Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
  • Used SQL Profiler for debugging issue, performance tuning whenever necessary.
  • Generated on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
  • Dropped and recreated the indexes on tables for performance improvements. Tuned SQL queries using execution plan for better performance.
  • Querying of source and target database for unit testing.
  • Maintain Operators, Categories,Alerts, Notifications, Jobs,Job Steps and Schedules.
  • Monitored connections, locks andperformance of SQL server.
  • Used Team Foundation Server (TFS) to keep Database Objects under Source Control.
  • Used UC4 for Scheduling Jobs Daily and Weekly Jobs.
  • Worked with SQL Server Agent for scheduling Jobs.
  • Converted SQL Server Agent Jobs to UC4 Jobs.
  • Designing and building data load procedures usingMS SQL Server.
  • Used TFS (Team Foundation Server) for keeping Database Objects under Source Control.
  • Performance:Troubleshoot system issues performance tuning using SQL Server Profiler and Database Engine Tuning Advisor for better performance.
  • Involvement in defining scope for new releases and helping business in solving existing issues.
  • Provide24 X 7 supportsto all production, development and staging.

  Environment: MS SQL Server 2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Crystal Reports Version 10, SQL Server Analysis Services (SSAS), MDX, Oracle PL SQL Developer, C#.NET, XML, UC4, Team Foundation Server (TFS), Microsoft Visio.

  Confidential, NY

  MS SQL Developer/ Reports Developer

  Responsibilities:

  • Experienced in participating meetings with business users to gather the requirements.
  • Interacted with business users and collect the required information (BRD) for creating Data Model using ER Studio.
  • Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications by using T-SQL.
  • Created partition tables for very large database for better performance.
  • Participated Databases Architecture and Data Modeling design.
  • Designed dynamic SQL Server Integrating Services (SSIS) Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
  • Used Logility demand planning software to forecast the demand.
  • Deployed SQL Server Integrating Services (SSIS) packages and Reports to Production Servers.
  • Involved in Designing, Developing and Testingof the ETL(Extract, Transformation and Load) strategyto populate thedatafrom various source systems feeds usingSQL Server Integrating Services (SSIS).
  • Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).
  • Reported all events and requirements through established reporting mechanisms in SQL Server Reporting Service (SSRS).
  • Responsible for creating complex reports like Drill down and Sub Reports using SQL Server Reporting Service (SSRS).
  • Created ad-hoc queries from SQL Server databases for custom reporting needs using SQL Server Reporting Service (SSRS).
  • Created Tabular, List, Matrix, Charts, Ad-hoc reports using SQL Server Reporting Service (SSRS).
  • Reported all events and requirements through established reporting mechanisms in SQL Server Reporting Service (SSRS).
  • Created report models for Report Builder 2.0 and managed reports using Report Manager.
  • Maintained system monitoring jobs and provide high availability support.
  • Used Visual Source Safe (VSS 2005) for keeping Database Objects under Source Control.
  • Fully supported change management procedures.
  • Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
  • Provide24 X 7 supportsto all production, development and staging.

  Environment: MS SQL Server 2005, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), Report Builder 2.0, MS SQL Server Analysis Services (SSAS), OLAP, C#.Net, UML, Visual Source Safe (VSS 2005).

  Confidential, Northbrook, IL

  SQL Developer

  Responsibilities

  • Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis.
  • Responsible for writing SQL queries, stored procedures, views by using T-SQL.
  • Used SQL Profiler and Query Analyzer to optimize queries and stored procedures.
  • Designing and generating Parameterized, Drilldown, Ad hoc and Sub-reports using Report Builder and MS SQL Server Reporting Services (SSRS) based on the requirements.
  • Used custom logging to have more detailed information of the work flow.
  • Deployed MS SQL Server Reporting Services (SSRS) Reports to Production Servers.
  • Responsible for troubleshooting and problem solving during package development and deployment.
  • Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
  • Involved in documentation of whole project majorly which helps the supporting team in having a better understanding of the system.

    Environment: MS SQL Server 2005, SQL Server Reporting Services (SSRS), DTS, Data Analyzer, Excel, SQL Profiler, Windows XP, MS Office.

    Confidential

    Systems Analyst

    Responsibilities

    • Responsible for technical documentation, user documentation and requirements specifications. Developed flow diagrams, documented the high level and user level documentation, developed user guides.
    • Participated in requirements gathering and design sessions based on business processes, requirements and system designs.
    • Developed Requirement specifications and process diagrams including context, dataflow diagrams in MS-Word and MS-VISIO.
    • UML was used for Visual modeling and a detailed Use Case Specification was developed to describe the design, architecture and dynamic behavior of the system.
    • Use Case analysis using UML and RUP was done to meet the changing Customer Requirements and complexity of the project.
    • Framed a detailed agenda for JAD. Facilitated JAD sessions.
    • Analyzed requirement document by identifying ambiguous, incomplete and incorrect requirements.
    • Managed change of the requirements and associated requirements to other requirements for traceability using Rational RequisitePro.

    Environment: RUP, Rational RequisitePro v.7, MS Visio 2003, MS Excel 2003, MS PowerPoint 2003, SQLServer 2000, Windows 2000