SUMMARY

• 6+ years of strong experience in teh IT industry as aSQLServerDeveloper(SSIS,SSRS,SSAS) wif sound business analysis skills.
• Experience wif complete SDLC life cycle, which includes requirement gathering, analysis, design, development, maintenance and implementation.
• Experience in writing T - SQL scripts such as tables, views, indexes, stored procedures, triggers, cursors, tables, user defined functions, relational database models and SQL joins.
• Hands on Experience in Table Design creating Clustered Indexes, Non-Clustered Indexes, complex joins and SQL Scripts for Views and Materialized Views.
• Worked wif CTE, temp tables and effective DDL/DML Triggers to facilitate efficient data manipulation.
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) wif good knowledge on SQL Server Analysis Services (SSAS).
• Worked on Report Writing for understanding each client business reporting requirement, designing, creating and maintain of simplex to complex reports.
• Worked wif creation of SSRS reports like tabular reports, parameterized reports, drilldown, drill through, sub reports, charts etc.
• TEMPHas very good ETL experience using SSIS for Data Extractions, Transformations and Loads.
• Worked extensively on Extraction, Transformation, loading data from Oracle, DB2, Access, Excel, Flat Files and XML using DTS,SSIS.
• Exceptional ability in Interacting wif Business users to analyze teh business process and transforming requirements into screens, performing ETL, documenting and rolling out teh deliverables.
• Experience in transforming unstructured data from various data sources using SSIS like Conditional Split, Lookup, Merge Join and Sort.
• Solid ability to create OLAP cubes usingSQLServer analysis services (SSAS).
• Good understanding of Normalization /De-normalization, Normal Form and database design methodology. Expertise in using data modeling tools like MS Visio and Erwin Tool for logical and physical design of databases.
• UsedExecution Plan,SQL Server Profilerto trace teh slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Write TSQL statements for retrieval of data and Involved in performance tuning of TSQL queries and Stored Procedures.
• Capable of writing PL/SQL scripts and also had good knowledge on Oracle Database.
• Worked on ticketing tools like I-Space and Remedy for change request management and incident tickets.
• Ability to handle multiple tasks, Initiative and Adaptable, Self-motivated, organized team player wif strong problem solving and analytical skills and total commitment to teh organization goals.

TECHNICAL SKILLS

Databases: SQL Server 2014/2012/2008 R2, Oracle 9i/10g/11g.

Languages: C, C#, Pl/SQL, T-SQL, SQL, Python, UNIX, JAVA, HTML, CSS, JavaScript

Data bases: MS SQL Server 2005/2008/2012 , Oracle 10g, Teradata

BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services(SSAS)

DB Tools: Studio (BIDS), Visual Studio 2013, SQL Profiler, DQS, Toad for SQL server

Methodologies: Agile, Waterfall, SDLC

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

SQL BI Developer

Responsibilities:

• Experienced in installing, configuring, upgrading, monitoring and administrating teh SQL Server 2012, 2014.
• Involved in development and implementation ofSSIS,SSASandSSRSapplication solutions for various business units across teh organization.
• Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.
• Directly responsible for teh Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• UsedSSISfor ETL processes,SSRSfor Reporting needs andSSASfor Analytics reporting including SharePoint integration.
• Created highly complexSSISpackages using various Data transformations like conditional splitting, Fuzzy Lookup, For Each Loop, Multi Cast, column conversion, Fuzzy Grouping, Script Components, error handling.
• Generated Custom ETL scripts usingSSIS2008 R2 and develops unit testSSISload processes for performance check.
• Developed various complex reports and manage those usingSQLServer Reporting Services (SSRS2008 R2).
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• DesignedSSRSReport Model Projects in BI studio and created, modified and managed various report models wif multiple model objects, source fields and expressions.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Wrote and integrated stored procedures to generate teh special reports according to client’s need.
• Extensive Knowledge inSSASstorage and partitions, and Aggregations, calculation of queries wif MDX, Data Mining Models, developing reports using MDX andSQL.
• Designed OLAP cubes wif star schema and multiple partitions usingSSAS.
• Understanding teh OLAP processing for changing and maintaining teh Warehousing Optimizing Dimensions, Hierarchies and adding teh Aggregations to teh Cube.
• Involved in writing MDX queries and performance optimization of theSSAScubes for calculated members and measure groups.

Confidential

SQLBI/SSIS/SSAS/SSRS DEVELOPER

Responsibilities:

• Experienced in installing, configuring, upgrading, monitoring and administrating teh SQL Server 2008 R2, 2012.
• Handled complex SQL queries includes insert, update, merge data, stored procedures, triggers, UDFs, views, joins and indexing.
• Experienced in report building 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 in handling Microsoft SQL Server Integration Services (SSIS) for building high performance data integration solutions including extraction, transformation, and load. Multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
• Experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimensions using SQL Server Analysis Services (SSAS).
• Experience in Designing, Creating, Deploying and Processing of Cubes usingSSAS.
• Experience in creating and managingSSASTabular models, creating Dimension and Fact Tables.
• Extensive experience in relational and dimensional data modeling for creating logical and physical design of database and ER diagrams using multiple data modeling tools like ERWIN, ER Studio.
• Developing reports like tabular, graph, matrix and deployed them on SharePoint server.
• Created Distributed Partitioned Views, Debugging/Troubleshooting Stored Procedures, and upgrading existing ones.
• Developed a data warehouse consolidating data from variousSQLApplication databases.
• Prepared ETL design documents for implemented work flows and loaded teh documents in teh project share point site.
• Able to work independently or as part of a team to achieve business objectives and to make decisions under pressure.

Confidential

Database Developer Intern

Responsibilities:

• Trained and worked on Database administration like installing, configuring, upgrading teh SQL Server, database creation, database security, access control, database backup and recovery.
• Worked as adeveloperin creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and otherSQLjoins and statements for teh applications
• Performed Data mapping for extraction and loading. Responsible for Disaster Recovery, backups, database optimization.
• Used SSIS to transform data intoSQLdatabase via FTP from Text files, MS Excel as source. Manage security, assign permissions, roles. Designed scripts to automate teh maintenance tasks.
• Heavily involved in query optimization and troubleshoot long running queries.
• Administer and troubleshootSQLSERVER AGENT jobs. Wrote complex stored procedures, triggers and functions.
• Scheduling Jobs and Alerting usingSQLServer Agent. Used Performance Monitor andSQLProfiler to optimize queries.
• Enhanced teh performance of database servers. Worked on deadlocks issues and minimized teh occurrence of these situations.