SUMMARY:

• Over 8 + years of Business intelligence developer experience in Systems Analysis and Design, Testing and Maintenance, and Software/Database Development in Client/Server systems, Data warehousing and applications for Different domains.
• Experience in data warehouse development with Integration Services (SSIS), Analysis services (SSAS) and Report development (SSRS).
• Proficient in SQLServer and T - SQL(DDL and DML) in constructing Tables, Normalization techniques on database Tables.
• Experience in creating Stored Procedures, Views, User Defined Functions, Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers.
• Experience in optimizing the database by creating various clustered, non-clustered indexes and indexed views.
• Sound knowledge of software development life cycle (SDLC) with substantial experience with object oriented analysis, design, development, testing, implementation, deployment & maintenance of projects.
• Strong knowledge in database design features including ER Diagrams, normalization, tables, Temporary tables, constraints, keys, data dictionaries, and data integrity.
• Extensive experience in developing complex Stored Procedures, Functions, Triggers, Views, Cursors, Indexes, CTE's, Joins and Sub queries with T- SQL.
• Experienced in Importing/Exporting Data from various data sources like Excel, Oracle, DB2 and Flat file using DTS utility. Involved in transformation of OLAP data to the Data Warehouse using DTS and SQL commands.
• Extensive experience in writing and executing scripts for validation and testing of the sessions, data integrity between source and target database and for report generation.
• Leads the planning, analysis, design, implementation, maintenance, and control of the organization’s server-class databases.
• Worked Extensively on ETL process using SSIS packages.
• Experience in Converting DTS packages into SSIS packages.
• Expertise in creating Ad-hoc Reports, Drill-Down, Drill-Through, Cascaded, Pivot, Matrix and Tabular Reports for different business domains depending on the specifications and requests.
• Analyzed SQL queries using Execution plan, Query Analyzer, SQLProfiler and database Engine tuning Advisor.
• Hands on experience in using tools like Index Tuning Wizard, SQL Profiler and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Knowledge of developing Baseline and Change Control Documents to prevent unauthorized alterations on a project and understand/control consequences of changes to the approved project baseline.
• Extensive knowledge of creating Data Dictionaries, Data Models, and Data Flows (context levels) and understand existing models.
• Scheduled reports for Daily, Weekly, Monthly reports on sales and marketing information for various categories and regions based on business needs usingReporting services (SSRS).
• Strong conceptual, analytical, and design skills with leadership qualities. Able to work with a team or individually with excellent communication skills, and ability to meet deadlines in a fast-paced work environment.

TECHNICAL SKILLS:

BI Tools: SQL Server Integration Services (SSIS), SQL Server ReportingServices (SSRS), SQL Server Analytical Services (SSAS).

Databases: Microsoft SQL Server 2008/2005/2000, MS-Access, Oracle 8i/9i/10g/11i

Languages: T-SQL, PL/SQL, C, VB Script, C, C++, C#,ASP .NET, XML, HTTP, Basic JavaScript

Operating System’s: Windows 7/Windows XP/NT/2000, UNIX, DOS, Windows Server2003/2008 and Mac OS Systems

Tools: Microsoft Visual Studio 2005/2010, Adobe Creative Suite, Dreamweaver

Architecture: Relational DBMS, Client-Server Architecture, OLAP, OLTP

PROFESSIONAL EXPERIENCE

Confidential CA

SQL/BI Developer

Responsibilities:

• Experienced with SSIS in creating, loading, and modifying new packages or existing packages and add or configure components, making changes in object by using Control Flow Tools and Data Flow Tools and then validating them inSQLServer Data Tools for Visual Studio 2012.
• Created ETL SSIS packages both design and code to process data to target databases.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers.
• Developed complex T- SQLqueries and designed SSIS packages to load the data into warehouse.
• Expert in designing and generating reports using SQL server reporting services (SSRS) and excel pivot tables.
• parameters pick list, matrix, score cards, dash boards, KPI reports, gauge charts
• Expert in creating and scheduling SQL server agent jobs and alerts, scheduled reports for daily, weekly, monthly
• Reports on sales and marketing information for various categories and regions based on business needs using reporting services (SSRS).
• Responsible for the design/creation of business requirements used to continually improve the quality and efficiency of the business system and documentation.
• Interacted with the Business users directly for the creation of new reports, Involved in the meeting with the team for the improvements of the old reports.
• Created various SSRS dashboard reports for commission, sales and profit analysis.
• Performing data transfers between different homogeneous/heterogeneous systems (excel, ms access, oracle and db2)
• Design and develop data loading programs to support real time data loading toNetezzaData Marts
• Interacted directly with the customers regarding the requirements for the report.
• Create reports include formatting options such as grouping, sorting, drill-down, parameter prompts.
• Created reports complex reports such as vendor score card reports, different brand comparison reports, Product brand sales report.
• Developed reports with different styles using table, ad hoc reports, sub reports and matrix.
• Experience in tuning SQL queries & improving the performance of the database.

Environment: Microsoft SQL Server 2000/2005/2008/2012 R2 Enterprise edition, SQL server Business Intelligence Development Studio (SSIS, SSRS), BIDS, Windows 7, XP, Internet Information Server (IIS), MS Excel 2007

Confidential, San Francisco, CA

SSIS/SSRS Developer multi tire

Responsibilities:

• Working closely with Team lead and Business Analysts to identify and specify business requirements
• Developed SSIS Packages to extract data from various data sources such as MS Access, Excel and flat files into SQL server 2008 using different transformations, Derived column, Sort, Row count.
• Worked with different Control flow tasks in creating SSIS packages especiallyfor Loopandfor Each Loopcontainers withExecute SQLandScript Tasks.
• Implemented custom logic in SSIS packages script task and script component using C#.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Performed data migration using tools like DTS, BULK INSERT and BCP between different homogeneous/heterogeneous systems and SQL Server.
• Worked withMaster SSIS packagesto execute a set of packages that load data from various sources onto the Data Warehouse on a timely basis.
• CreatedSSISPackages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleansed data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Experience with SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints.
• Expert in calculating measures and dimension members using mathematical formulas, and user-defined functions.
• Deploying and scheduling Reports using crystal reports to generate all daily, weekly, monthly and quarterly Reports including current status.
• Expertise in mapping data between Data Marts and the Enterprise Data Warehouse.
• Expert in web designing using HTML, CSS, XML and JavaScript to display reports on the server.
• Generated reports using SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.
• Worked on MS SQL Server tasks such as data loading, batch jobs, BCP, DTS, Linked Servers and Indexes. Maintained the database consistency with DBCC at regular intervals.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Managed index statistics, Tables, Views, cursors and optimizing queries by using execution plan for tuning the database.
• Maintained data integrity by performing validation checks and also fine-tuned the database objects and server to ensure efficient data retrieval.

Environment: MS SQLServer 2008 Visual Studio, MS SQLServer 2008 Management Studio, T-SQL, SQLServer Integration Services (SSIS), SSRS, SQLServer CE client, ASP.Net, vb.Net, VB Script, MS Access, Windows 7, Internet Information Server (IIS), MS Excel 2007

Confidential - Bridgewater, NJ

SQL/BI Developer

Responsibilities:

• Designed high level ETL (Extraction Transformation Loading) architecture for overall data transfer from the OLTP to OLAP with the help of SSIS Business Intelligence Development Studio.
• CreatedSSISPackages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Involved in SSIS development to extract data from third parties and populate into the table.
• Scheduled SSIS packages by creating the corresponding job tasks.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Migrated DTS packages to SQL Server Integration Services (SSIS) using package migration wizard.
• Created complex ETL Strategies to populate the data warehouse/data-mart facts and dimensions.
• Created Ad-Hoc reports as per client requirement using stored procedure.
• Created weekly and monthly reports as per requirement using SSRS and Scheduled Reports to be delivered to User on demand Basis or run on daily, weekly and monthly basis in SSRS report Manager.
• Involved in handling parameterized reports and drilldown reports in SSRS 2005/2008
• Worked with Flat Files, OLE DB Source, and Excel Source loading
• Developed reports using efficient data retrieval techniques.
• Involved in complex T-SQL programming.
• Resolved any deadlocks issues with the Databases/Servers on a real-time basis.
• Evolved in the creation and maintenance of index using database engine tuning advisor wizard, Query optimizer, and selected the best indexing plan to be deployed.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Maintained client relationship by communicating the daily status and weekly status of the projects.

Environment: Microsoft SQL Server 2000/2005/2008 R2 Enterprise edition, SSAS, SSIS, SSRS, BIDS, Microsoft Visual studio, Windows server 2003, Internet Information Server (IIS), MS Excel 2007

Confidential, Lake Worth, FL

SQL Developer

Responsibilities:

• Gathered user requirements, Analyzed and designed of software and database solutions.
• Migrated DTS packages using DTS editor wizard inSSIS, validated and tested all packages on development server.
• Performance tuning, including collecting statistics, analyzing explains & determining which tables needed statistics. Increased performance by 35-40% in some situations.
• Designed multiple data and application databases for various applications across the enterprise.
• Created & modified databases, performed capacity planning, allocated space, granted rights for all objects within databases, etc
• Performing data transfers between different homogeneous/heterogeneous systems (excel, ms access, oracle and db2) and sql server as a part of data migration, data maintenance and other SSIS tasks.
• Defined Granularity with in a measure group and drill through actions.
• Wrote the queries for the drill down reports, Identified and added the report parameters.
• Formatted the reports using the Global variables and expressions, deployed the generated reports on to the server.
• Transformed the complex business logic and calculations into coding.
• Gathered information about the system and assisted in the development of deliverables. Worked with the clients to gather system requirements.
• Established and created program evaluation and reviewing for the project lifecycle.
• Maintained oversight of version control of documents within the SharePoint repository.

Environment: MSSQLServer … MSSQLIntegration Services, Access Database, MS Excel, Window XP, MS Word, Visual Studio.

Confidential

SQL Developer

Responsibilities:

• Wrote T-SQL code for creating cursor and handling the data validations.
• Involved in various stages like development, system Analysis and design.
• Suggested creating Clustered and Non-Clustered indexes on tables.
• Involved in project planning with project managers.
• Maintained the table performance by following the tuning tips like normalization, creating indexes and collect statistics.
• Installed and maintained MS SQL Server 2000/2005.
• Created Ad-Hoc reports for business users using SSRS.
• Created Database Objects - Tables, Views, User defined functions, Triggers, Stored Procedure and Roles.
• Created DTS packages to get data from different sources, consolidate and merge into one single source.
• Implemented different types of constraints on tables.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Transformed the complex business logic and calculations into coding.
• Designed a report on the monitoring of Server Performance using Task Manager and Performance monitor.
• Created levels of Data Flow Diagram using Microsoft Office Visio.
• Created and kept the Entity-relationship Diagram and Data Dictionary up-to-date after any alterations were made to the metadata and data in each table.

Environment: MS SQL Server2000/2005, MS Access, Query Analyzer, DTS, BCP, SQL Profiler, Import & Export Data, Windows 2005 Server.