SUMMARY

• Over 8 years of IT Experience as MS SQL Server Developer, and involved in Design, Development and Support of MSSQL Server 2005/2008/2008 R2/2012, PL/SQL, for various business domains like Pharmaceuticals, Constructions, financial services and Health Care.
• Strong understanding of key requirements capturing techniques like Joint Application Development sessions (JAD), Rapid Application Development (RAD),SME interview, Requirements workshops, etc. to capture key project requirements.
• Extensive work knowledge of key software development methodologies like Agile, RUP, RAD, SDLC, SCRUM etc. by working in all key phases doing requirement gathering, testing analyzing etc.
• Extensive work experience in creating user stories, heading daily standups, SCRUM calls while working in Agile environment.
• Extensive experience working with data teams in configuring, mapping, profiling, transforming, and cleansing data between different Databases, backend systems, internal and external entities and systems
• Expertise in reviewing Test Procedures, creating Test plans, defining System & Integration Test Cases, executing Test Cases, Test Data reviewing, maintaining and executing detailed Test scripts for User Acceptance Testing (UAT), analyzing bugs, interacting with team members in fixing defects
• Worked in assisting the testing team in creating testing documents, logging defects, generate bug reports, providing clarification on errors in contrast to requirements to assure sound delivery of project.
• Worked extensively on ETL process, by creating Extraction requirements, Transformation rules, and load procedures and requirements for many projects.
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration and Metadata Management Services.
• Over 8 years of IT Experience as MS SQL Server Developer, and involved in Design, Development and Support of MSSQL Server 2005/2008/2008 R2/2012, PL/SQL, for various business domains like Pharmaceuticals, Constructions, financial services and Health Care.
• Excellent working skills in MS SQL Server business intelligence tools SSIS, SSRS and SSAS. Experience in SDLC and Agile environments of project including requirement gathering, creating technical specifications, development and testing of end product.
• Involved in Migrating MYSQL to SQL Server 2008 databases.
• Experience in installing and configuring SQL Server 2014/2012/2008 R 2/2008/2005/2000 SQL Server versions.
• Used Erwin modeling tool for designing database objects.
• Development of Automated notification when SQL Server Backups and schedule maintained jobs.
• Created Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets. Developed several SSRS reports including Drill Down, Drill through cascading parametric reports
• Hands on experience in understanding the database design and their relational integrity, along with Constraints, OLAP, OLTP, Cubes and normalizations.
• Well experienced in ETL methodology for designing and developing Extraction, Transformation and Load processes in dynamic and high volume data environments using various tools such as SQL Server Integration Services.
• Expertise in integration of data from diverse data sources like Oracle, Excel, MS Access, and DB2 to MS SQL Server by using Import Export Wizard, DTS, and SSIS.
• Extensively worked on developing and debugging Informatica mappings, sessions and workflows.
• Validation of Informatica mappings for source compatibility due to version changes at the source.

TECHNICAL SKILLS

Platforms: Windows 2003 Enterprise, Windows 2000 Datacenter, Windows NT & XP

Database/Data warehousing: MS SQL Server 2014/2012/2008 R2/2008/2005 & 2000/, T - SQL, PL/SQL, OLEDB, MySQL, Oracle 12/11g/10g/9i/8i, Installation, Upgrade, & Migration, Performance Tuning, Capacity Planning, SSMS, TOAD, DTS, OLTP, BCP, SSIS, OLAP

BI Tools: SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), Business Objects, Data Services, Abinitio, Pentaho, Data Stage, Informatica, Crystal reports XI, Cognos

Applications: C/C++, C#, Java, HTML, CSS, Java Script, XML, XSLT, PHP, ASP.Net, VB.NET, UNIX, LINUX Visual Studio 2008/2010/2013.

Desktop: MS Office Suite, Word, Excel, Access, PowerPoint, Outlook, Dreamweaver, Fire Fox, Power BI, Tableau

Methodologies: Agile, Water Fall, Scrum, SDLC.

Database Design Tools and Data Modeling: MS Visio, Star Schema/Snowflake Schema modeling, FACT & Dimensions tables, Erwin.

Operating Systems: Windows Server 2008R 2/2008/2003/2000 , UNIX, LINUX, DOS

PROFESSIONAL EXPERIENCE:

Confidential, Nashville, TN

SQL Server BI Developer

Responsibilities:

• Involved in Designing, Developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS
• Involved in Migration of Databases fromSQLServer 2008 toSQLServer 2012 using SSIS and third party tools of Pragmatic work DTSxchange
• Worked on SSIS 2012 project deployment, configuration to configure different environments, catalogs, Environment parameter mappings and configured log settings at the server level for packages deployed in Integration services catalogs
• Worked with loading data from different source like DB2,SQLserver, XML, flat files and Excel using SSIS and worked with error handling and logging using stored procedures
• Involved in creating SSIS packages to migrate large amounts of data
• Worked with Various control flow task such as ExecuteSQLTask, XML Task, File System Task, FTP Task, Send Email Task, Data Flow Task and used various containers such as Sequence container, for container, for each container for iterating through files and ADO objects
• Used various Data flow transformation such as Data conversion, cache transform, derived columns, export column, copy column, Lookup, Fuzzy lookup, Multicast transformations
• Worked with slowly changing dimensions (SCD) Type 1, 2 and 3 for capturing historical data as per the business requirements
• Used various SSIS event handlers in SSIS packages to capture the events such as Pre-execute, post-execute for initializing settings related to the task, and used Error Event handler to log the custom errors and send Email notifications as alerts using Send Email Task to the application development team and production support teams
• Extensively performed Data processes, Data Mappings, Data dictionaries, Data pulls and Reporting solutions
• Worked in optimizing the performance of queries with modification in T-SQLqueries, stored procedures, functions removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes
• Created cubes to support specific analysis conducted by upper management, the cube included few materialized views as well as fact arranged by topic
• Worked with QuestSQLCompare table and the data compare between Dev to Test and Test to prod environment
• Created and modified stored-procedures, triggers, cursors, and user defined scalar valued and table valued functions, and views
• Created complex T-SQLqueries using inner joins, outer joins, common table expressions, local tables, table variables, global table variables, CROSS apply, OUTER apply etc.
• Created DML scripts for data manipulation and data insertion as part of production support activities and as part of new functionality or enhancements release deployment scripts
• Created drill-through, drill-down, crosstab and tabular reports usingSQLServer Reporting services (SSRS)
• Created reports involving sub-reports in master-detail reports in SSRS
• Worked with Shared data sources, datasets and used Oracle 11g with ODP.Net Data provider
• Worked with parameterized reports involving cascading parameters in drill down, drill through and tabular reports passing parameters to the child reports
• Created report subscriptions and scheduled it for email delivery and network drive delivery options
• ConnectedTableauserver to publish dashboard to a central location for portal integration
• Expertise inSQLServer administration, Database Design, Performance Analysis, and Production Support for complex Databases and worked with error handling and logging on SSIS packages
• Worked with .Net applications to build batch jobs using console applications and scheduled inSQLServer Agent jobs
• Worked with ADO.Net for data retrieval using ODP.Net provider for Oracle and nativeSQLServer data provider for MSSQLserver 2008R2 and 2012
• Consumed and published WCF web services in .Net in IIS 7.5 Web server and configured various end points for clients to access over protocols such as HTTP, TCP, Named pipes
• Worked with ASP.Net web applications to build middle tier business components
• Worked with console jobs to pull and post files to the FTP using C#. Net
• Analyze user requirements, functional and technical specifications, preparing test plans
• Used TFS (Team foundation server) source control tool to check in all the codes in daily basis

Environment: Windows XP, MicrosoftSQLServer 2005/2008/2012 , SQLEnterprise Manager, DB2, Oracle 9i/10g/11g, VB.net, C#.Net, ASP.NET,SQLServer Reporting 2008, Microsoft Excel, TFS, Visual Source Safe, and SSRS 2005/2008, SSIS/DTS, SSAS 2000/2005, Tidal Automation

Confidential, Dublin, OH

SQLDeveloper/Business IntelligenceDeveloper

Responsibilities:

• Good knowledge of Relational Database Modeling/Loading and Dimensional database modeling concepts
• Interacted with Business users for requirement gathering and created traceability mapping documents and System requirement specifications (SRS)
• Migrated DTS packages to SSIS packages and individually designed MSSQLServer 2008 database, coded stored procedures (T-SQL)
• Worked with XML Data sources to load data through ETL SSIS Packages using for loop containers to load the files
• Created package with different data sources (SQLServer, Flat Files, Excel files, etc) and loaded the data into target tables by performing different kinds of transformations usingSQLServer Integration Services (SSIS)
• Created parent-child SSIS packages using Execute Package task and passing parameters to the child packages from parent package
• Worked with various data flow transformations such as Lookup, Fuzzy lookup, term lookup, copy column, export column, import column, derived column, script component as source, destination and transformation, data conversion, multicast, conditional split transformations
• Worked with various control flow task such as sequence container, for loop container for files iteration and ADO record object iteration
• Worked with XML and XPath queries using XML Task in extracting data from xml into package variables
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various business users and production support, application support teams
• Created data mapping document, Schema mapping documents (Source to Destination Tables) and design documents based on business requirements
• Deployed SSIS Packages into Production environment and used Package configuration to export various package properties to make SSIS packages environment independent
• Created scheduled jobs usingSQLAgent to automate the business processes using SSIS packages and generated scripts for migration to different environments
• Worked with various log providers in SSIS packages such as Files, Event Log, andSQLServer etc
• Extensively used database transactions in SSIS packages at the package level and task level
• Worked with Checkpoint files and configured checkpoints in SSIS packages
• Involved in debugging SSIS Packages using break points
• Worked with Bulk copy program (BCP) using BCP Utility and loaded large data into staging tables for ETL processing
• Created various database objects such as tables, stored procedures, triggers, views, materialized views, user defined functions involving scalar valued and table valued functions
• Created clustered and non-clustered Indexes, database relational constraints
• Worked with ranking functions such as Row Number, Dense rank, Rank etc
• Created temporary tables and table variables while creating complex queries inSQLServer 2005/2008/2012
• Worked with T-SQL, PL/SQLscripts and created dashboard reports usingTableau
• Utilized T-SQLdaily in creating custom views for data and business analysis
• PerformedTableautype conversion functions when connected to relational data sources
• Developed OLAP cubes, wrote queries to produce reports usingSQLServer Analysis Services (SSAS) and Reporting Services (SSRS), Dashboards
• Built SSRS reports from various heterogeneous sources likeSQLServer, Oracle
• Creating Parameterized Reports, drill down, Sub-reports usingSQLServer Reporting Services 2008/2012
• Created SSRS reports from various migrated data sources into simple dashboards for easy reviewing
• Worked with Report builder to build report models for Adhoc reports
• ConfiguredSQLmail agent for sending automatic emails when a SSIS process failed, succeed or completed
• Created ASP.NET web forms using C#. NET and deployed in to IIS Web server
• Created with .Net user controls (ASCX) and custom controls for reusability in asp.net web forms such as Address control, user information control, login control etc.
• Worked with ADO.Net in data retrieval using Data Reader, data set, Data relations, Data adapter etc
• Consumed SOAP based web services in console jobs and ASP.Net web applications
• Worked with .Net File I/O operations for file movements and clean up batch jobs to delete the Log files
• Environment:SQLServer 2005/2008/2012 Enterprise Edition, SSIS, T-SQL, SSRS, Dashboards, SSAS, Windows Server 2012, C#, ASP.Net, Oracle 9i, Erwin 7x, Visual Basic 6, BMC Control-M Workload Automation

Confidential, Albany, NY

SQLServer & SSRS/SSISDeveloper

Responsibilities:

• Adept at rebuilding and reorganizing indexes on various tables using SSIS Package tasks and T-SQLScripts
• Worked with Database size exceeded 4 million rows and Developed Excel web parts for reports, KPIs and connected to dashboards on MOSS 2007
• Created tables, procedures, user defined functions (UDF), views etc
• Developed indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage
• Writing complexSQLqueries using table joins (inner and outer), temporary tables, and table variables and designing, developing, implementing, and maintaining reporting frameworks
• Used Common table expressions (CTE), MERGE, PIVOTS in complex querying for data retrieval and data manipulations
• Running DBCC consistency checks, and fixing data corruption in databases
• Monitoring Execution plans inSQLServer and Explain plans in Oracle to enhance the performance of the queries
• Ensuring database integrity, indexing, segmentation and recovery and update database design over time
• Extensively worked on MS-SSRS, SSIS and Slowly Changing Dimensions (SCD) for type 1, 2 and 3 for loading and maintaining historical data
• Developed/Monitored ETL packages with different data sources (SQLServer, Flat Files, Excel files, etc.) and loaded the data into target tables by performing different kinds of transformations usingSQLServer Integration Services (SSIS)
• Worked with different connection managers such as HTTP Connection, SMTP Connection, Flat File Connection ADO.NET Connection, OLE DB Connection, MSMQ Connection etc
• Troubleshooting and Performance tuning usingSQLProfiler, Quest Performance Analyzer and Database Tuning Advisor (DTA) to diagnose historic data as well as current ones
• Worked with performance tuning of slowly running SSIS packages using Parallelism technique
• Created packages where independent tasks are executed using independent sequence containers in parallel and used Precedence constraints for control flow
• Reduced the usage of blocking transformations such as SORT, PIVOT, and MERGE etc.
• Improved the Package performance by removing the indexes on the tables before processing and rebuilding the indexes on load of the data
• Used Package level MaxConcurrentExecutable for concurrent executions to control the threads on theSSIS Task based on the server specification limitations and configured Engine threads in dataflow task
• Configured Rows per batch, Max Insert commit size to reduce the burden of using the Temp database
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to respective user groups
• Worked with Various data flow transformations, and Control flow tasks in the SSIS Packages to accommodate the business requirements without compromising the package performance and business necessities
• Worked with Log providers for logging and debugging of the packages
• Involved in creation of dimensions using Star, Snow Flake schemas
• Created several MDX queries according to Business requirements
• Wrote MDX queries and expressions for use in Front EndBIApplications
• Built SSRS reports from various heterogeneous sources likeSQLServer, Oracle
• Created ad-hoc queries from DB2 database for custom reporting needs.
• Created Drill down, drill through, linked and sub reports using SSRS 2005/2008R2
• Built Standard parameter reports and also cascading parameter reports using Shared datasets, data sources etc
• Worked with hierarchical SSRS reports using various levels of Row Grouping and column grouping
• Worked with conditional formatting and report expressions for dynamic display of SSRS report fields
• Created reports from various data sources into simple dashboards for easy reviewing
• Worked with Data Driven subscriptions by passing report parameters to the SSRS Reports based on the subscription query
• Worked with SSRS Reporting web services in ASP.NET web and Windows forms applications using C#. NET to generate the reports in different rendering formats such as PDF, EXCEL etc
• Configured the Report Security by granting access to the relevant user groups based on the user roles
• Worked with Cached reports by setting the cache properties in the Report Manager. Also worked with Snapshot reports to render the report from snapshot
• Worked with ASP.NET Report viewer to display the SSRS Server side report on the ASP.net web forms

Environment: SQLServer 2005/2008R2 Enterprise Edition, Oracle 9i, DB2, SSIS, T-SQL, SSRS, Dashboards, SSAS, Windows Server 2003, C#, ASP.Net, Erwin 7x, Visual Basic 6, .Net Framework 2.0/3.0

Confidential, Albany, NY

SQLServerDeveloper/BIDeveloper

Responsibilities:

• Understanding the business requirements and documenting the specifications for ETL Processing and reporting applications
• Created new database objects like tables, stored procedures, Functions, Triggers, Indexes and Views using T-SQLinSQLServer 2008
• Migrated legacy DTS packages fromSQLServer 2000 toSQLServer 2008 SSIS Packages
• Optimized the performance of queries with modifications in T-SQLqueries, removed unnecessary columns, and eliminated redundant and inconsistent data
• Created efficient, robust SSIS packages for data movement and loading with error checking and well-documented code
• Created SSIS Packages to integrate data coming from Text files and Excel files
• Created SSIS packages to validate, extract, transform and load data to data warehouse databases
• Built connections to extract data from AS400, mainframe/db2 and Oracle
• Migrated old data from MS Access intoSQLServer 2008 using SSIS Packages in Business Intelligence Development Studio
• Involved in creating packages in SSIS Designer using various Control Flow Tasks and Data Flow Transformations to implement business requirements
• Regularly used for Loop Container, For Each Loop Container, Sequence Container and Control Flow Tasks like ExecuteSQLTask, send mail Task, Script Task, Execute Process Task, Execute Package Task, File System Task, Script Task, Execute Package Task and Data Flow Task
• Involving in designing, coding, testing of the SSIS Packages
• Implemented Event Handlers for Pre-Execute, Post-Execute, On-error events for Error Handling in SSIS packages and sent emails using SMTP Send Mail Task to relevant user groups
• Deployed SSIS packages in toSQLServer and used command line DTEXEC utility by dynamically passing command line arguments as parameters to the SSIS Package during runtime
• Worked with Script component as a transformation using C#.Net as the programming backend
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Created stored procedures for cleaning, manipulating and processing data between the databases
• Extensively used Joins and Common Table Expressions to simplify complex queries involving multiple tables
• Developed complex Stored Procedures and views to generate various tabular, matrix, drill-through reports, parameterized reports and linked reports using SSRS
• Worked with SSRS Charts in SSRS Reports for better visualization of business data using PI, BAR, LINE, COLUMN, AREA charts
• Worked with Indicators in SSRS Reports to indicate the business data trends
• Used VB Code in Report Code to write custom functions which are used for conditional formatting and hide and show of report elements using SSRS Expressions
• Worked with crystal reports and migrated the legacy crystal reports into SSRS 2008
• Deployed SSRS Reports shared data sources in to report manager and configured the report security
• Worked with CLR Stored Procedures in .NET by building CLR Stored procedure library and deploying the assembly intoSQLServer for further use in T-SQLStored procedures
• Worked with VB.NET and C#.NET in building custom components in .NET applications
• Extensively used ADO.NET provider for data retrieval fromSQLServer 2005/2008 in ASP.NET web applications and windows services

Environment: Data Transformation Services (DTS),SQLServer 2000/2005/2008 R2 Enterprise Edition, ODBC, BIDS, Business Objects, Crystal Reports 8.0, SSIS, SSRS,SQL, IIS

Confidential

SQLDeveloper

Responsibilities:

• Requirement gathering and worked according to the CR.
• Worked under the senior level guidance.
• Data validation/Reconciliation report generation.
• Code Development as per the client requirements.
• Created Stored Procedures, User defined functions, Views and Wrote T-SQLcodes maintaining query standards for the project.
• Involved in the development backend code, altered tables to add new columns, Constraints, Sequences and Indexes as per business requirements.
• Perform DML, DDL Operations as per the Business requirement.
• Creating views and prepares the Business Reports.
• Resolved production issues by modifying backend code as and when required.
• Used different joins, sub queries and nested query inSQLquery.
• Involved in creation of sequences for automatic generation of Product ID.
• Part of team for analyzing and implementing the physical design for database.
• Created Database Objects like tables, Views, sequences, Synonyms, Stored Procedures, Functions, Packages, Cursors, Ref Cursor, and Triggers.
• Testing of code functionality using testing environment.
• Writing complex Stored Procedures to meet the business requirements.

Environment: MSSQLServer 2000/2003, Excel, Query Analyzer windows NT/2000 server & Professional.

Confidential

SQLServerDeveloper

Responsibilities:

• Managing Installation, Configuration and Maintenance of MSSQLServer 2005.
• Created and manages schema objects such as tables, views, indexes, procedures, triggers and maintaining Referential Integrity.
• Participated in re-design and development of back-endSQLServer database, wrote queries, triggers and stored procedure.
• Involved in creating different flow services required for data transformation, creating & validating IS Schema, IS Document types.
• Involved in the configuration of JDBC Adapter using different templates like custom adapters using differentSQLQueries and Stored Procedures.
• Installation of replication server, configuration and monitoring the replication between two sites, implemented Transactional replication.
• Created and running DTS Packages for Import and Export of Heterogeneous Data.
• Scheduled the backups for Databases and Transaction log. Performed restoration operations. Suggested backup strategies.
• Responsible for unit testing, writing design documents and uploading it to share point server.
• Creation of schema objects, granting of roles and privileges to the users, compilation of procedures etc.
• Used DDL and DML for writing triggers, stored procedures and data manipulation.
• Created database administrative job of Security, Backup/recovery, ODBC connections etc.,
• Provided support to the Applicationdeveloperson the application databases.
• Responsible for creating stored procedures and SSIS packages as part of the ETL process to populate the data marts.

Environment: SQLServer, Windows 2000/XP, MS Access,SQLProfiler, DTS, T-SQL, Query Analyzer, MS Excel.