SUMMARY

• 8+ years of experience in IT as Sr. Business Intelligence working in various domains such as Finance, Insurance and Healthcare in 2012/2008R 2/2008/2005/2000 Windows Environment and other tools and technologies.
• Experienced in software development life cycle in all phases.
• Experienced in client requirement analysis, Physical and Logical design & development (using normalization and SQL Server Enterprise Manager).
• Experienced in relational data modeling using Visio.
• Experienced in resource planning, coding, debugging, testing, deployment, support and maintenance of business applications using MS SQL Server 2000/2005/2008 , SQL Server Integrated System, SQL Server Analysis Services and SQL Server Reporting Services.
• Expertise in TSQL, creating and using Stored Procedures, Views, User Defined Functions, implementing Business Intelligence solutions using MS SQL Server 2000/2005/2008 .
• Have good experience in creating Indexes in observing Business Rules and creating Effective Functions.
• Experienced in defining queries, generating drill - down report in Crystal Reports.
• Used the SQL Server Import/Export wizard to migrate the Heterogeneous Databases such as Oracle and MS Access database, flat files to SQL server 2005/2008.
• Adept in creating Ad-hoc, Cross-Tab, Drill-down and Sub-Report using RDL.
• Experienced in creating many complex SSIS packages wif complicated transformations.
• Expertise in designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and ad-hoc reports using SQL Server Reporting Services based on client requirements.
• Experience in working wif Tableau reports.
• Very proficient in working wif large Databases - DB2, Oracle, Teradata
• Hand on experience in developing & deploying Cubes using SQL Server Analysis Services involving multidimensional data.
• Good knowledge of defining and deploying Cubes using MS SQL Server 2005/2008/2012 Analysis Services.
• An enthusiastic and goal-oriented team player possessing excellent communication, interpersonal skills wif good work ethics.

TECHNICAL SKILLS

• MS SQL SERVER /2005/2000
• MS SQL SERVER Management Studio
• Business Intelligence Development Studio
• SQL Server Enterprise Manager
• Oracle
• DB2
• C++
• SQL
• T-SQL
• MS Excel
• MS ACCESS
• DTS
• SQL Server Integration Service (SSIS)
• SQL Service Analysis Service (SSAS)
• SQL Server Reporting Service (SSRS)
• SQL profiler
• MS VISIO
• Windows NT/2000/XP
• ASP.net
• VB.net

PROFESSIONAL EXPERIENCE

Confidential, Portland, OR

Sr. SQL Server BI Developer

Responsibilities:

• Responsible for gathering and defining user requirements to meet customer business needs.
• Expert in Migration Database objects from Oracle to T-SQL using Functions, Inline Views, Stored procs, Merge, CTE, Dynamic SQL, Except, union and union all and Various Built in functions.
• Migrated existing ETL process form Informatica to SSIS, and changed the existing process and used various new features in SSIS to make the ETL process reliable and robust.
• Created SSIS package to handle flat files, CSV files by implementing incremental updates to the process.
• Created custom components using Script task and followed best practices while designing the SSIS packages.
• Created SSIS package for date cleansing and used various transformation like Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task and created SSIS package to load data from OLTP to OLAP.
• Converted Classic ASP and ASP.net reports into SSRS by using complex expressions to calculate, Group, Filter, Parameterized the report according to the requirement.
• Worked on designing the standard tabular reports, including Drill Down and Drill Through functionality and Graphical representation for analysis.
• Created Tabular reports, matrix reports, List reports and sub reports in SSRS.
• Create Tableau worksheets, design, develop dashboards and publish the report.
• Working wif large volumes of datasets and loading delimited files into Tableau server.
• Designed and develop user-interface screens using .Net technologies: ASP.Net and C#. (4.0 Framework).
• Enhanced existing product wif new features, improved existing features depending on the team view.
• Designed the application wif extensive use of Object Oriented Programming techniques like inheritance, data hiding, encapsulation and polymorphism.
• Designed new ASP reports by using new MVC 2 architecture and created HTML reports.
• Involved in Migrating and redesigning SSAS cube from Cognos to SQL Server.
• Tuned cubes for better performance by deleting unused aggregation and by using Usage Based Optimization in SSAS.
• Worked on creating Cognos catalog for users to access data from cubes.

Environment: Visual Studio 2013,2010, C#, Classic ASP, ASP.Net 4.0 framework, VB.net, Java Script, MS SQL Server 2012/14, MS Visio, Subversion, Cognos, Tableau.

Confidential, Beaverton, OR

Sr. SSIS/SSAS/SQL Server Developer

Responsibilities:

• Creating reports from cubes- using either SQL Server Reporting Services (most recent experience wif SQL Server 2008R2)
• Creating complex stored procedures wif TSQL
• Creating reports from OLAP (online analytical processing) or SSAS (SQL Server Analytical Services)
• Creating SSAS cube using Multidimensional and Tabular model.
• Created complex Stored Procedures for better performance to generate reports.
• Created and tuned stored procedures, triggers and tables.
• Created reports by extracting data from the data set using SQL server reporting services 2010.
• Designed and deployed reports wif Drill Down, Drill Through and drop down menu option and parameterized and Linked reports.
• Deployed and scheduled reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status.
• DesignedSSIS packages to Extract data from different sources like SQL server 2008, MS Excel, MS Access; transform them and then load intoDimension and Fact tables in Data warehouse using SSIS.
• Used various SSIS data flow transformations, such as Data Conversion, Conditional Split, Derived Column, and Lookup which were used for Data Scrubbing and Data Validation Checks during staging, before loading the data into Data Warehouse.
• Developed SSIS packages using for each loop inControl Flow to process all excel files wifin folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table.
• Involved in extracting data from heterogeneous sources, such as CSV and Excel files.
• Created and modified Stored Procedures, Functions, and Indexes
• Designed and developed SSIS packages, Stored Procedures, Configuration Files, Tables, Views, Functions, and implemented best practices to maintain optimal performance.
• Used VB script in script components for data transformations.
• Used Expressions to lookup data from multiple datasets as well as multiple databases.
• Created standard report subscription and data driven report subscriptions.
• Developed different kind of reports such as Sub Reports, Charts, Matrix reports, Linked reports.
• Involved wif Query Optimization to increase the performance of the report.
• Involved wif SSIS Source/destination mapping from M3 to Enterprise Data Warehouse.
• Developed reports for business end users using Report Builder wif Updating Statistics

Environment: MS SQL Server 2008 R2, SQL Server Integration Service (SSIS), SQL Service Analysis Service (SSAS), SQL Server Reporting Service (SSRS), T-SQL, Visual Studio 2008, VB.net, MS Access, SQL Profiler, SharePoint server, windows XP, MS Excel.

Confidential, Bedminster, NJ

SSIS Developer / ETL Analyst

Responsibilities:

• Migrated SQL Server databases to latest version 2008 from SQL server 2005.
• Developed SSIS packages to Extract, Transform and Load (ETL) data into the data warehouse database from heterogeneous databases/data sources (SQL, Oracle, Excel Sources).
• Used various SSIS tasks such as Conditional Split, Derived Column, lookup which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Optimized the performance of queries by removing unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established Joins and created clustered/non-clustered indexes wherever necessary.
• Generated reports on wealth information, account information, research reports using ad-hoc reporting to be used by the clients and advisors.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Created Queries in T-SQL, Stored Procedures, and Views to store the data of clients and advisors.
• Worked wif business analysts to identify, design and implement solutions for extraction and integration of data, to and from databases and data marts for the purposes of data extraction and reporting using SSRS.
• Generated performance based reports using SSRS for the managers to show active service engagements against various measures like pipeline, time, area, and price range.
• Used VSS to store, run, view, edit and revert back to different version of the design in case of a system crash.
• Created packages wif different control flow options and data flow transformations such as Conditional Split, Multicast, Union all and Derived Column etc.
• Designed and built star and snowflake dimensional models creating facts, dimensions, measures, cube and established data granularity.
• Experience in using Bulk Copy program (BCP) to import and export large amounts of data in and out of SQL Server databases.
• Implemented mechanisms to accelerate query performance, including aggregations, caching, and indexed data retrieval and optimizing the design of dimension attributes, cubes, and multidimensional expressions (MDX) queries.
• Implemented database standards and naming convention for the database objects and documentation of all the processes involved in maintaining the database for future reference.

Environment: MS SQL Server 2005/2008, SQL Server Management Studio, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Visual Studio 2008, SQL profiler, Excel and Oracle, Business intelligence development studio (BIDS), MS Access, MS Excel and Oracle

Confidential, Peapack, NJ

Insight Data Warehouse Architect/Developer/Support

Responsibilities:

• Actively participated in gathering user requirements and system specifications.
• Created Reports in MS Access and worked as MS Access Admin where users used to pull data from SQL Server in MS Access and modify the data in the SQL Server table through MS Access.
• Migrated SSIS/SSRS/SSAS objects from SQL Server 2005 to SQL Server 2008
• Designed Data Warehouse database from OLTP database for reporting from SSAS Cubes.
• Designed different Measure Groups in the single cube for different business segment and created Calculated Measures using MDX and Tuned Cubes for better performance by deleting unused Aggregations by using Usage Based Optimization tool in SSAS.
• Used MDX Queries for pulling data out of the Cube and modified MDX query by using various functions (NONEMPTYCROSSJOIN, SETTOSTR, STRTOSET, LEVELS, and ANCESTOR).
• Designed SSAS Cube reporting using Microsoft Office Front page and SharePoint Designer.
• Created SSRS reports using SSAS cube and Oracle as a data source by using various components like Matrix, Table, Document Map, Linked reports and created subscriptions to the reports.
• Created Dashboards using DUNDAS components (Maps, Gauges, Charts, Calendar) in SSRS.
• Created Dashboards and KPI’s using Microsoft Office Performance Server 2007 and deployed the Workspace in to the server.
• Created integrated environment wif SharePoint for SSRS which will automatically render the report using SSRS and place a copy in the SharePoint Server.
• Worked as a Team Foundation Server (TFS) admin and created reports from TFS.
• Designed and develop user-interface screens using .Net technologies: ASP.Net and C#. (4.0 Framework).
• Designed the application wif extensive use of Object Oriented Programming techniques like inheritance, data hiding, encapsulation and polymorphism.
• Created SSIS package by using Analysis service process task for processing the Partitions, Dimensions, and Measure Groups and used transformation like Data conversion, Derived column, Fuzzy grouping and lookup, Merge, Sort, Union all, conditional split etc…
• Created SSIS package for loading data into the data warehouse from OLTP database and for pulling Event Logs errors in all servers using WMI scripts and load into the database.
• Created SSIS package for executing Job logs details and sends the report which SSIS job failed and in which server the job resides to Insight Data Warehouse team and Created SSIS package for Web Activity Usage to know how many hits are their for the particular report by pulling data from Log files.

Environment: Visual Studio 2005/2008, SQL Server Management Studio, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), MS Office SharePoint Server 2007, MS Office Performance Server 2007, Crystal Reports, C#, ASP.net 4.0.

Confidential

MS SQL Server BI/ETL Developer

Responsibilities:

• Translated business requirements into data analysis, data sources and reporting solutions for different types of consumers.
• Transformed data from different data sources like Oracle and DB2 to SQL Server 2005 using OLE DB connection providers by creating various SSIS packages.
• Moved the data from the appropriate databases to end database and maintained batch log files.
• Well versed wif the usage of variables to make the packages dynamic and scheduling the package in SSIS (sequential scheduling).
• Generated reports using the parameterized stored procedures for about physical collection of credit cards, delinquency customer Month to till date
• Built advanced reports using query parameters, report parameters, filters, interactive sorts, Drill Down, Drill through and Groupings.
• Scheduled reports to run weekly, monthly and quarterly based on the data to be reviewed by the manager.
• Created Dimensions and Cubes and deployed it on to the server for the managers to analyze the business of Physical Collection of Credit Cards.
• Created indexes on the database tables and generated trace events to improve the query performance and optimize data access.

Environment: MS SQL Server 2005/2008, Management Studio, Business intelligence development studio (BIDS), SQL Server Integration Services(SSIS), SQL Server Analysis Service(SSAS), SQL Server Reporting Services(SSRS), T-SQL, Visual Studio 2005, MS Access, MS Excel, DB2, Oracle, windows 2000/2003 VB.net.