SUMMARY:

• A self - motivated individual with professional experience in Software development and Configuration Management, looking to explore new technical knowledge for professional advancement and be productive in results
• Over 6+ years of IT working experience in SQL Server database developing and implementing using SQL Server 2014/2012/2008 R2/2008/2005, Microsoft SQL Server integration services ( SSIS), Microsoft SQL Server Reporting Services ( SSRS), Microsoft SQL Server Analysis Services ( SSAS) and MDX for data warehouse and data mart solutions in Financial, Retail, Healthcare, Insurance; Config. Mgmt. and in Active Directory Domains as a Data Analyst
• Expert in Performance Tuning, Handling Indexes, and Query Optimization
• Experienced in creating complex SSIS and DTS packages for ETL purposes. Implemented complicated transformations in the development of SSIS packages.
• 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 SSRS
• Expert in Data Extraction, Transforming and Loading ( ETL) using various tools such as SQL Server Integration Services ( SSIS), Log Shipping, DTS, Bulk Insert and BCP.
• Experience in working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Experienced in designing high level ETL architecture, creating, configuring and fine tuning ETL workflows designed in DTS for overall data transfer from the OLTP to OLAP with the help of SSIS
• Expertise in generating reports using SQL Server Reporting Services (SSRS), Crystal Reports, and Excel spreadsheet.
• Expert in creating simple and parameterized reports and also complex reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs, Drill Down, Drill Through, Cascading, parameterize reports using SSRS in Business intelligence development studio (BIDS)
• Experienced in Designing, Building the Dimensions, Cubes with Star Schema and Snow Flake Schemas using SQL Server Analysis Services (SSAS) in SQL Server 2012.
• Proficient in designing Data Mart and Data Warehouse using Star and Snowflake Schemas
• Expert in creating cubes and dimensions, handling multi-dimensional reports
• Generated the Reports with all the subcategory Information to Business users .
• Created and Executed the Stored Procedures and Complex Queries for Reports
• Proficiency in utilizing ETL tool Informatica Power Center 9.1/8.x for developing the Data warehouse loads with work experience focused in Data Integration as per client requirement.
• Extensively worked with Informatica Tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation Developer and Informatica Repository Manager.
• Excellent knowledge and experience in data warehouse development life cycle, requirement analysis, and Repository management, implementation of Star, Snowflake schemas, and slowly changing dimensions.
• Experienced in setting up project baselines, branching, merging and taking regular backups of the source in ClearCase, TFS, CVS, SVN, GIT and Perforce.
• Have Migration experience in moving from one Source Control Version tool to another.
• Experienced in trouble shooting, configuring and deploying enterprise applications in Web Sphere, BEA Web Logic and Tomcat as well. Extensive experience in using Continuous Integration.
• Extensively worked with third party database tools like TOAD, PL/SQL Developer and SQL*PLUS.
• Wrote stored procedures and User Define Scalar Functions to be used in the SSIS packages and SQL scripts.
• Technical documentation of different lifecycle deliverables and user manuals, creating the test plans for the Database Testing.
• Ability to work within an aggressive and demanding project schedule and environment.
• Excellent Interpersonal and Communication skills, coupled with strong technical and problem solving capabilities.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, C, JAVA, T-SQL, VB.Net, ASP.Net

CM Tools: SCM, IBM Rational Clear Quest, WebLogic, Tomcat, WebSphere, Eclipse, Maven, Cruise control, UNIX Make, Ruby.

IDE Tools: Eclipse, Toad Test Framework JUnit, Perforce

Other Tools: JIRA

Automation/Build Tools: Jenkins, Chef , Puppet, Sonar Cube

RDBMS: Oracle 11gR2/10g/9i/8i, SQL Server 2014/2012/2010/2008/2005/2000, MS Access

ETL: MSBI, Informatica Power Center 8.6.1/9.1, Informatica Designer, OLTP, OLAP

Front end tools: Developer 2000 (Forms and reports 6i, 9i, 10g)

Tools: /Utilities: SQL*Loader, Export, Import, TOAD, PL/SQL developerOracle SQL Developer, SQL Server Management studio, SSIS, SSRS, SSAS, DTS,: Microsoft Visual Source Safe, SQL Query Editor, Visual Studio 2010/2008

BI Tools: SQL Server Reporting Tools (SSRS), SQL Server Integration Services(SSIS), SQL Server Analytical Services (SSAS), Performance Point Server 2007

Operating Systems: Windows Vista/XP/2000/ 2003, Windows 7, HP-UX, Linux

Web Development Tools: ORACLE Application 9ias, Tomcat, HTML, XML, SOAP Services

PROFESSIONAL EXPERIENCE:

Confidential, Troy, MI

SQL BI (SSIS, SSRS) Analyst

Responsibilities:

• Created Star schema dimension modeling for the data mart using Visio and created dimension and fact tables based on the business requirement.
• Developed measures and dimension members using multi-dimensional expression to meet additional needs that were calculated from existing measures
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS
• Gathered report requirements and determined the best solution to provide the results in either a Reporting Services report, Analytical Cube or an Excel pivot table
• Designed SSIS packages to Extract data from different sources like SQL server 2014, MS Excel, MS Access, transform and then load into Dimension and Fact tables in Data Warehouse using SSIS
• Developed SSIS packages using for each loop in Control Flow to process all excel files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table
• Produced operational reports in SSRS i.e. drill-down, drill-through, dashboard and matrix reports. Responsible for ETL through SSIS and loading Data to DB from different input sources.
• Used ETL for data flow from different source files like XML, Excel, Tables, and Views to other databases and files with proper mapping.
• Generated monthly and quarterly reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS
• Implemented Complex Logging in SSIS Packages.
• Used various transformations in SSIS like Lookup, Fuzzy grouping, Row count Transformations
• Converted manual reports pasted together into parameter driven stored procedures to be used with Microsoft Reporting Services 2012
• Involved in the team, with Sr. DBA for Database Administration Jobs like Security & User Admin, Job Scheduling & Notification, Database backups & Restoring, Index Management etc.
• Attained legacy data to use as a source to develop new reports previously compiled and maintained manually
• Developed functional and technical documentation to assist in the design, development and/or maintenance of deliverables
• Created SSRS Data Model projects using Microsoft Visual Studio 2012 and using Report Builder for report server to create reports
• Responded to AD-HOC requests and special projects that require immediate attention while at the same time maintaining deadlines on existing requests.
• Developed and maintained system documentation, diagrams and flowcharts.
• Worked with project manager and technical leads for resolution of technical issues.

Environment: MS SQL Server 2014/2012, SSRS, SSIS, SSAS, SQL Server Profiler, Visual SourceSafe, Windows 8, Enterprise Manager ASP.Net, C#.

Confidential

Config. Mgmt. Engineer

Responsibilities:

• Worked closely with the Development Team in the design phase and developed use case diagrams.
• Coordinating the resources by working with Project Manager s for the release and all the other Operational Projects
• Worked within the Confidential Cloud environment for integration & Deployment stages.
• Performed Dev - Ops for Linux and Windows platforms.
• Source code configuration tools Subversion and GIT used for different projects.
• Maintained versioning of Artifacts by Sonatype Nexus for continuous Integration
• Focused on automation, integration, monitoring and configuration management using Confidential .
• Carried Deployments and builds on various environments using continuous integration tool Confidential
• Monitored developed applications and fixed bugs.
• Automation of test cases is done by integrating the HP QC plug-in with Jenkins Server which will automate
• Whenever there is latest package available through the CI server.
• Build, configured and support Application team environments.
• The Code quality of Java applications is implemented by Sonar Cube, which is automated by configuring with CI Server.
• Wrote code and designed continual updates.
• Developed Ruby scripts to ensure continuous deployments.
• Worked on Confluence to share knowledge with other teams
• Completed load and performance testing of extremely complex systems.
• Responsible for managing NO SQL databases ( Cassandra) for Confidential
• Streamlined applications delivery to get applications out to customers faster.
• Utilized SQL database systems.
• Completed load balancing and did proxy of systems, servers and components.
• Maintained SVN repositories for Dev-Ops environment: automation code and configuration
• Developed automation and deployment utilities using Ruby and Bash.
• Wrote custom monitoring and integrated monitoring methods into deployment processes to develop self- Healing Solutions for Confidential
• Developed and implemented the software release management for the release of web applications.

Environment:: Subversion, Jenkins GIT, Java/J2EE, JDK, ANT, MAVEN, DB2, UNIX, Windows XP, Web Logic, HP Quality Center.

Confidential

Software Developer

Responsibilities:

• Involved in understanding requirements, analyze new and current systems to quickly identify required sources and targets
• Involved in preparation of technical documentation, design transformations that are consistent with the goals of the existing data warehouse, and worked with the development team to implement the solution
• Worked on legacy code to analyze problems, confirm requirements, and create designs, code and testing.
• Experience in designing, developing, and testing Informatica extract/transform/load processes in a Data Warehouse.
• Extensively worked on Mapping Parameters, Workflow Variables, Mapping Variables, and Session Parameters.
• Used the Workflow Manager to create Workflows, mapplet and Tasks.
• Wrote SQL over ride queries in the required transformations.
• Used design and development techniques that resulted in efficient, maintainable, and high quality ETL processes.
• Used problem solving skills and quickly understood relationships between data with little documentation.

Environment: Informatica Power Center 8.6, Oracle 9i, PL/SQL, Toad 7.6, Windows XP, UNIX.

Confidential

IT Security Analyst

Responsibilities:

• Creation of user ID’s and providing them with relevant rights on domain using ARS (Active Directory Tool).
• Performing tasks like adding / removing and managing user accounts, giving permissions on share drives and applying group policies
• Responsible for providing Lotus Notes, Citrix, AS400, VPN, HUB, Safe boot support.
• Monitoring External drive access and usage through the Sanctuary device control Monitor
• Handling crucial incidents through the Incident management procedures, Investigation-diagnosis and resolving the issues within agreed SLA’s.
• Monitoring servers globally using Citrix and Confidential ADMIN (creation and deletion of admin accounts).
• Recertification of risk applications and accounts across Confidential Globally using Aveksa tool
• Instrumental in providing Training to the new joiners’ and sharing process and Technical knowledge
• Attend quality review meetings with business and process owners
• Completing the work of providing network security on AS/400 systems for protecting the files
• Providing security support for distributed computer systems
• Creating a centralized system to protect from unwanted network corruption
• Performing the task of diagnosing and resolving technical problems in internal resources
• Planning as well as preparing detail practices and procedures on various technical processes
• Maintaining firewall administration, network security, intrusion detection, and virus protection
• Determining security alarms and preventing and controlling network intrusion

Confidential

Sales Engineer

Responsibilities:

• Provide pre - and post-sales services, including business analysis and bid support, to identify customer technical requirements relating to technical and commercial solutions.
• Worked with design engineers, architects, contractors, owners throughout sales process, from client specifications to post-sales technical support.
• Served as first point-of-contact between Sales team and Engineering group for technical sections in bids and proposals
• Assisted in technical preparation of quotations and proposals.
• Sell industrial Rigging products (Material handling equipment s), including Twin path polyester Slings, Crosby rigging, Hardware, camlock safe lifting clamps.
• Also sell Transformer lamination sheets i.e.and Transformers of different Capacities.
• Responsible for the technical support concern about the products.
• Evaluate and suggest product & service solutions in line with client needs and requirements.
• Utilize Gmail, other web services and associated software s to coordinate client relationship.
• Generate and submit weekly Sales status and progress reports to senior level management to Support business directives.
• Provide Technical and business support for south region sales team. Work with clients to determine Corporate/Industrial needs and Requirements.
• Generated leads and followed up on sales opportunities. Named Top Junior Sales Engineer in 2003.
• Prepare presentations for customer, assist in reviewing topology and closing opportunity.
• Participated in senior meetings which Confidential to Strengthen Cooperation Networks